Opening Access 2003 to view tables etc

[Guest]

At Canada Post we were on Access 2000, in order to open to the tables rather
than the application we had to hold down the Shift key when clicking on the
file we were opening. This does not work now when I try it it launches the
appication front end, how do I get to my tables???? Any help is greatly
appreciated

 

[Guest]

Hi, Art.

This does not work now when I try it it launches the
appication front end, how do I get to my tables????

The shift bypass key works in all versions of Access that I can remember
(which is back to Access 95), so if it's not currently working, then someone
has disabled it. Unless that someone also implemented User-Level Security,
then you can re-enable the shift bypass key by opening the Immediate Window
and typing the following:

CurrentDb.Properties.Delete "AllowBypassKey"

.. . . and then pressing the <ENTER> key. Close the database and reopen it
again by holding the <SHIFT> key down until the database is completely open.
All of the startup options will be ignored and your tables will be visible in
the Database Window.

HTH.
Gunny

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