Password protection for access to Tables, queries, reports and forms

[vmolasi]

Hello everyone,

Could someone advise me on how can I enable password protection for access to the backend of an Access database. The user can use the database only through the User interface forms. Access to the backend of the database i.e. tables, queries, forms, reports, Macros and VBA code should be password protected.

I am aware of the startup conditions wherein the developer can restrict access to the various toolbars. This however does not help me as it can be bypassed by pressing the Shift key while opening the database.

Thanx

 

[JeremyNYC]

Use the user-level security built in to Access. Look for articles on "Disable Shift Bypass". I think the code may be in the Security FAQ, which you'll want to read a few times anyway. There's a copy on my website or you can get it from MS. Before you play with securing your database, and before you disable the shift bypass, MAKE BACKUPS of your database. Before you run the code to disable the shift bypass, put in a back door--some completely unobvious way to re-enable it, or some way that is only available to administrators of the database. In one of my apps, I've got a form that only administrators can see. On the form is a toggle to enable/disable the shift bypass (called Admin mode, so other people will know what it is). That way, you can open the database in normal mode, where the shift key won't do anything, click the toggle, close the db, and get back in holding the shift key down and your looking at the database window.

Start with the FAQ.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.