Web Development

General discussion


"Locking Down" MS Access

By Bob_M ·
I have been given a MS Access DB that a client has been using to conduct surveys. The link starts the database with an autoexec macro in order to provide the user with a form view. The problem is that the users can still directly pull up the database and modifiy the "app". Is there a way I can lock everyone out of everything but the form view but still allow access by either a password or the use of some obscure keystroke combination?
Any and all help would be greatly appreciated...I've looked throught the manuals I have but I cannot seem to find anything.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Should be...

by ObiWayneKenobi In reply to "Locking Down" MS Access

There should be a startup option to display the form automatically when the application is started.. I forget the name of the option at the moment, but it disables the normal data view unless you, I believe, hold SHIFT when you open the program.

Collapse -


by gsquared In reply to "Locking Down" MS Access

Keep the developer version of the database as an MDB/APD file, but only let end-users have access to a compiled MDE/ADE file.

Tools -> Database -> Make MDE/ADE file

Anyone using the compiled version of the database won't have access to editing the forms, macros or scripts.

Then use Tools -> Startup in the compiled file to turn off database view, Access special keys and the ability to edit menus. (Uncheck those 3 boxes.)

That will lock down the database for most people. The startup options can still be bypassed by holding down shift while opening the project, but since the forms and such are compiled, they won't be editable. (Can still edit data, just not any of the code.)

Since you'll still have the source file, you can still edit code, forms, reports, etc.

It works well that way for me. I also have the only copy of Access in the office. Everyone else uses the runtime files (developer edition of Office XP), which means they can't open the database window even if they do hold down shift, but that costs a little more money than the standard edition. (More for my copy, zero for eveyone else. Overall, it's been a huge savings.)

Related Discussions

Related Forums