Accessing VBA Code without Opening Database 1

[Bandenjamin]

Ok here's an interesting problem.

We have a database that opens with a password. One of the users of this database had the idea to set up a macro to automatically close the database and put in in the OnTimer Property of a hidden form. They set the interval for the timer to be 1000 not realizing it was ms....

The problem. Now the databse only stays open for 1 second, which is obviously not long enough to get to the form properties and kill the macro from running. Any suggestions?

 

[PaulBricker]

Well, you could create another new database and import all the database objects (File...Get External Data...Import) into your crippled db. Then just fix the problems.


Paul

 

[PaulBricker]

Sorry, I forgot to add that first, you can try holding down the Shift key when starting the db. Enter your password, then before you hit Enter, hold down the shift key and then enter your password. That may be all you need.

Paul

 

[Bandenjamin]

Worked perfectly. Thanks for the help.