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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.