Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock down application

Status
Not open for further replies.

pkw25

MIS
Mar 20, 2002
46
IE

I am developing an application in Ms Access 2003. Is it possible to lock down the table and code so that users don't have access to them ? At the moment if you press the shift key the user has access to everything.

regards
Paraic
 
The best way would be for you to first;
Disable the shift bypass key. You could enable from a command button on your switchboard.
Second, you could set a password in a Module design's Tools\Properties.
Third, you could make the application an .mde file.

For distribution I would definitely recommend .mde.
If you just have it local, I would set a password in any Module's design and also disable the Shift ByPass Key.




Thomas Bailey
a/k/a TomCat
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top