Link to home
Create AccountLog in
Avatar of ehess
ehessFlag for United States of America

asked on

How can I force Access MDB to open without accessing window-> unhide to see the database

I had a user corrupt an Access database yesterday.  I was able to recover it from a backup, but now when the database is opened you have to go to Window-->Unhide to see the database.  How do I force it to open without the unhide step?
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Hold down the Shift key until the MDB is completely open.

mx
There is also a keyboard shortcut after the DB opens, I believe it is F11 assuming shortcuts have not been disabled, in which case you have to use the Shift trick DatabaseMX suggested.  If the shift trick doesn't work it means you are locked out because AllowBypassKey = False.
Holding down the shift key will bypass any startup code and bring you directly to the database window - unless - ad groove mentioned - an AllowBypassKey property has been created and set to False.

mx
ASKER CERTIFIED SOLUTION
Avatar of jfrent
jfrent

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ehess

ASKER

Right on, the simple step was all I was looking for!  
ehess
Did you get into the database by holding the shift key ?

mx

Avatar of ehess

ASKER

I didn't want any additional keyboard steps other than File->Open for the database to open.  I did try to press and hold shift while the database was opening, but it never did anything.  I was able to accomplish the direct opening of the database by making the following change.  

Tools->Startup, check the checkbox labeled "Display database Window"