July 24, 2007 at 7:22 pm
I have an application I developed in Access 2003. When I upgrade the application to Access 2007, I cannot access any of the code I wrote in the 2003 version - says that the project is locked. I can't find out where to unlock it anywhere. Also code won't run the forms.
Barry
July 26, 2007 at 7:14 am
If you kept the 2003 MDB format, you might have to change the macro security level to enable the code to run. That "project is locked" message might be one of those stupid wrong MS error messages. If that is the case:
Click the Office button, click Access Options, click Trust Center Settings, click Macro Settings, then click the radio button for Enable all Macros... and then click OK twice to get back to Access. Close and then re-open your app, see if it works.
If you have used "unsafe expressions" such as ENVIRON() or Shell() then you might have to re-write for that to be 2007-compatible.
If you converted to the new ACCDB format, you might be using features that aren't supported in 2007.
I'll send you a PM with my private email address, maybe you could zip & send me both the "before" and "after" versions & I'll check it out.
July 26, 2007 at 4:39 pm
Thanks William - I have fixed the problem although I can't quite put my finger on how. I think you were right in that some of my code was not supported in 2007. I added the appropiate references and deleted some code that the program didn't use anyway and things started to work ok. Have since converted to ACCDB and rolled out to user using Access 2007 runtime and waiting to see if all is still ok in a week or two.
Thanks again - some good hints....
Barry
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply