Opening a DB with all macros etc disabled in MS Access 2003.

[AndrewG]

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. From the error message it looks as this is being caused by a
function which is being called when the db is opened.

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

 

[SteveM]

Is it an .mdb? If so, try holding down 'Shift' when opening the db.

The error you are getting is probably related to the linked backend database
that is not where it expects it to be and there is no recovery code to allow
you to re-link to another datasource.

Steve

 

['69 Camaro]

Hi, Andrew.

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 ?

Press the <SHIFT> key down and hold it while opening the database. Keep
holding the key down until the database is completely open. This will
bypass the startup options, so that no VBA code or macros will run on start
up.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[AndrewG]

That did it !

Thanks.

Andrew.

Hi, Andrew.


Press the <SHIFT> key down and hold it while opening the database. Keep
holding the key down until the database is completely open. This will
bypass the startup options, so that no VBA code or macros will run on start
up.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

That did it !

Thanks.

Andrew.

You're welcome. Good luck with the troubleshooting.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.