How to protect database (requiring Shift+Enter)

[carmela_wong]

How can I protect my database so that the end user needs to open it
using Shift+Enter?

Thanks

[Tom van Stiphout]

On 31 May 2006 11:29:34 -0700, ca**********@hotmail.com wrote:

Create a macro, and name it AutoExec.
Enter one action in it: DoCmd.Quit

-Tom.

How can I protect my database so that the end user needs to open it
using Shift+Enter?

Thanks

[carmela_wong]

Thanks for replying. How about if I want the users to be able to open
the database and get to the forms I have created for them to work with
but require Shift+Enter to access the tables?

Thanks again.

[Tom van Stiphout]

On 31 May 2006 13:39:00 -0700, ca**********@hotmail.com wrote:

You can hide the database window (Tools > Startup). Then use the
Switchboard Manager (Tools > Database Utilities) to create a main menu
which would allow the user to open any form or report. Modify the
AutoExec macro to DoCmd.OpenForm the Switchboard form.
This way, most users never need to use the Database window, and those
who do will know how to reveal it.

-Tom.

Thanks for replying. How about if I want the users to be able to open
the database and get to the forms I have created for them to work with
but require Shift+Enter to access the tables?

Thanks again.

[carmela_wong]

Great. Thank you!