Locked myself out of my database

[Guest]

I'm using Access 2003...created a new DB via wizard for Event Management.
I've been customizing the VB code for the forms for our use. My goal was to
have the database window out of sight behind the forms of the application so
nosy users wouldn't be able to directly open tables, etc.

In the Form_Open sub of the Switchboard form I changed this:
' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize

to this:
' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Close

Yeah. Stoopid, right? I go to fire the thing up and the database window
appears briefly and then closes. The switchboard form never appears because
apparently told it to close everything before the form even gets opened!

So my question is: Can I somehow stop the thing in the short window that I
have in order to get back into the code of the Switchboard form and change it
back? Is there any way to back into the thing now that I have effectively
painted myself out?

 

[Ken Snell [MVP]]

Try holding down the Shift key while you open the database. That disables
"startup" options.

 

[Guest]

Many thanks, Ken. That did the trick!

 

[Bob Howard]

Note that there is a way to even disable that functi0n, so be careful if you
even decide you want to try it! Start with a backup of the DB. Bob.

Many thanks, Ken. That did the trick!