database (.mdb) won't open


G

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' ?
 
Ad

Advertisements

G

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
 
Ad

Advertisements

G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top