database (.mdb) won't open

[Guest]

My application was OK last night, but when i tried to open it this morning I
got:

""Microsoft Office Access has encountered a problem and needs to close. We
are sorry for the inconvenience."

Access tries to compact & repair the database, but fails. I don't know
whether the problem is in untested code that tries to run when the .mdb loads
or if the database itself is corrupted.

Is there a way to start Access so that the code immediately goes into 'break
mode' ?

 

[Guest]

Try press Shift while opening your database. If fail, create a new MDB file
and import all objects from your old database, include Menus and Toolbar,
Import/Export Specs.
Good luck

 

[Guest]

Thanks, Khoa.

I got the mdb to open by holding the Shift key down when I selected the
shortcut to my db (from within Access) and when I clicked 'enable macros' on
the warning window. It opened OK. So, can I assume that the problem was in my
code?

If so, I will start commenting-out or setting breakpoints on all lines that
open/close other forms or do anything remotely potentially dodgy, and see if
I can find the offending line or routine.