By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

How to protect database (requiring Shift+Enter)

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

Thanks

May 31 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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


May 31 '06 #2

P: n/a
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.

May 31 '06 #3

P: n/a
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.


May 31 '06 #4

P: n/a
Great. Thank you!

Jun 1 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.