Tony
asked on
MS-ACCESS Application Security.
MS-ACCESS Application Security.
Hi, I need a compilation of security measurements to put in a ms-access application. Such as:
1. Users cannot see tables.
2. Users cannot see vba code.
3. Users cannot use Special keys : Keys such as Ctrl+Break, Ctrl+G, and the Shift key to bypass startup options in the database.
4. Users cannot see the Navigation panel at all.
5. Users cannot see any forms, queries, reports or any other object.
6. Any additional suggested.
Please advice.
Thank you.
Hi, I need a compilation of security measurements to put in a ms-access application. Such as:
1. Users cannot see tables.
2. Users cannot see vba code.
3. Users cannot use Special keys : Keys such as Ctrl+Break, Ctrl+G, and the Shift key to bypass startup options in the database.
4. Users cannot see the Navigation panel at all.
5. Users cannot see any forms, queries, reports or any other object.
6. Any additional suggested.
Please advice.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Be very careful when you are locking down the database. Make sure you have several backups, preferably as zip files to avoid accidental modification. Since all the lockdown steps will impede your ability to make changes, write yourself a procedure or in some cases, you can do this with code and only secure the database as the last step before distributing the new version.
I'm pretty sure if you search here and other places there are specific instructions on how to accomplish each step. I don't have them handy but perhaps someone else can post a link.
One additional thing I do is to rename the .accde as .accdr and also add code to force the app to only run in "runtime" mode.
I'm pretty sure if you search here and other places there are specific instructions on how to accomplish each step. I don't have them handy but perhaps someone else can post a link.
One additional thing I do is to rename the .accde as .accdr and also add code to force the app to only run in "runtime" mode.
1. Using Set options to hide the DBC (database window or Nav pane) and cut-off special keys such as F11.
2. Distribute as a .accde so the source code is not available.
On this:
"5. Users cannot see any forms, queries, reports or any other object."
Do you mean in design view? #1 and #2 would cover that.
Jim.