Opening the MDB

[Shell]

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

Thanks

 

[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

 

[OldKingCole]

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

Thanks

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!!

 

[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

 

[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.

 

[Chris O'C via AccessMonster.com]

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

Chris