Opening the MDB

S

Shell

In Access 2000, how do I determine, in code, if the mdb was opened using the
shift key?

Thanks
 
C

Chris O'C via AccessMonster.com

You can't. If the shift key is held down when the db opens, no code runs.

If you disable the shift key, the shift key is ignored when the db opens.

Chris
 
O

OldKingCole

In Access 2000, how do I determine, in code, if the mdb was opened using the
shift key?

Thanks
Click to expand...

Another method is to issue your app as an mde (rather than an mdb) -
from the menu Tools | Database Utilities | Make MDE File... Then
holding the Shift key will have no effect.

BUT Make sure you keep a copy of the MDB to future development!!
 
C

Chris O'C via AccessMonster.com

It doesn't matter if the file is an mde. It's whether the db's shift key
bypass has been disabled or not.

Chris
 
S

Shell

I'm not interested in disabling the shift key. All I want to know is how it
was opened. This would allow me execute one of two queried depending on how
the mdb was opened.
 
C

Chris O'C via AccessMonster.com

Sorry, there's no way to tell with vba code inside the db.

Chris
 
Top