program functionality

  • Thread starter Thread starter gator
  • Start date Start date
G

gator

I have designed a program for a client to install on his secretary's
computer. How do I set up the program where the user can only use a menu
created by me to get to certain forms? I don't want anybody except me to ge
tto tables, properties, code, etc.
 
Gator -

You'll want to set the options under Tools --> Startup.

Set the Display Form/Page to the Form that you want the user to start on
(example: frmMainMenu).

You'll want to uncheck the
Display Database Window,
Allow Full Menus,
Allow Default Shorcut Menus,
Allow Built-In Toolbars,
Allow Toolbar/Menu Changes, and
Use Special Access Keys check boxes.

You can select your custom menu in the Menu Bar drop down.

You will also want to lock your database so that holding down the shift key
doesn't allow access. You can use Albert D. Kallal's By Pass Shift Key Code
to lock your db, but anyone can also use it to unlock it.

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


Bryan..
 
i have set a database password with existing properties set per below.
Before I set the password, I could use the Shift key to open with full
functionality. Since I set the password, using the Shift key opens with the
limited functionality. How do I open it to get to full functionality?
 
Try holding down the shift-key after you enter the password (before you click
the OK button).

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top