Open database with macros disabled.

[AndrewGray]

Hello,

I have a 'legacy' Access DB which I need to get into.

Unfortunately there is a problem, whenever I try to open it (using MS Access 2003) there is an error (Disc/Network error 3043) and the database closes immediately.

How can you open an MS Access db with all macros/vba etc disabled, so that the code causing the error does not execute and I can find out what is going on ?

I have not been able to find any such options in the MS Access 2003 open dialog or menus.

Thanks,

Andrew

 

[The_Doc_Man]

You might be able to get some back-door info...

Open your database. Very carefully note the system clock time when you do. Let it die. (It was going to die anyway.)

OK, get to your control panel, look at the administration options, and open up the event viewer. Look into the events for that system clock time. You get a system, security, and applications log (three separate logs) by default. One of them might show you an error message that would help in identifying your problem. (OK, it's a long shot...)

 

[AndrewGray]

thx - Ill try it

Thanks - Ill give that a try.

However, I have now managed to get a little further - by opening the db as read only I am able to launch the debugger temporarily I still cant see much, but - ironically it looks as if the fatal error is caused by a bit of code that is trying to handle another error - doh !

Is it not possible to open the DB with all macros & functions disabled ?

Thx

andrew

 

[The_Doc_Man]

Macros can be disabled by XP but if it is VBA code, no.

But here's a hint. If the DB has a startup form, you can look up the F11 key and a couple of other ways to prevent startup forms from running. However, it is possible that the database designer disabled that ability. If so, then no, you cannot turn off everything.

 

[Moniker]

Have you opened the DB while holding down Shift? That stops all AutoExec macros and OnLoad events from running. If that's disabled, can you make a new DB and import the required tables/forms?

 

[MartyL354]

That is what I needed.

I had a single form that I opened modal. I put code in the On Unload Event to close the application (Application.Quit). If I tried to close the form then put it in Design mode I would get a cyclical error # 2046, The command or action "Quit" isn't available right now. I would then have to use Task Manager to close Access. I couldn't figure out how to get back to my code to change it.

Thank you kindly.

Marty