Log Database Opening without a Form

[rm]

Is there anyway to log an entry each time a MDB is opened without a
form. e.g. log an entry even if a user presses the "Shift" key when
opening the DB.

 

[Stefan Hoffmann]

hi,

Is there anyway to log an entry each time a MDB is opened without a
form. e.g. log an entry even if a user presses the "Shift" key when
opening the DB.

No, not really.


mfG
--> stefan <--

 

[Jeff Boyce]

Since the purpose of the "Shift" bypass is to bypass the normal startup,
anything you put into the normal startup for logging purposes would get,
well, bypassed!

It is possible, however, to disable that "Shift" bypass programmatically ...
but you, as developer, would still need/want to have a way to get to the
design interface, right?

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Douglas J. Steele]

As Stefan implies, using the Shift key means that no startup code runs, so
there's no way to force Access to do something!

If you need a logging capability such as you're describing, you'll need to
disable the ability to bypass the startup code by pressing the Shift key.

 

[Keith Wilby]

Is there anyway to log an entry each time a MDB is opened without a
form. e.g. log an entry even if a user presses the "Shift" key when
opening the DB.

No but you can disable the shift key to force a form to open.

Keith.
www.keithwilby.co.uk

 

[Jack Leach]

While you may not be able to log the opening of a database if the ShiftBypass
is applied, you can disable the shift bypass and password protect the toggle
to turn it on/off...

http://www.databasedev.co.uk/disable_shift_bypass.html

Then, at least, you could log the vast majority of openings. If you need
shift bypass (remember the password!!), enable it and restart the app (at
which point it won't log).

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)