Database Security

[JuniorWoodchuck24]

Access 2007

I've searched several threads and I haven't come across one that deals exactly with what I'm seeking. I developed a database for multiple users to access. I've set up user login tables that keeps user/pass/accessLevel information. So based on who signs in depends on the user access level. My issue is doing the following if possible.

User opens database and has to select user name and enter a password.
Based on who the user is they're given rights.

I'm trying to find out how to block the users ability to unhide objects, edit forms/reports in design view, and view VBA code. I know you can go into the Access Options and uncheck these boxes. My only concern is they can easily go in and check them back. Is there a way to prevent a user with a low access level from opening the Microsoft Access Options and checking the items?

 

[ghudson]

I am surprised that your searching of the forum did not find what you are looking for.

For starters, you need to disable the Shift key option to prevent the user from bypassing the start up options you mentioned.

I trust that you have split your database and each user has a local copy of the front end installed onto their computers' hard drive.

 

[Khalid_Afridi]

In addition to ghudson you should create a front-end/runtime application with all the codes removed or locked deign forms/reports with ACCDE/ACCDR extension for 2007 database.

 

[JuniorWoodchuck24]

Thanks for the info, but yah I've done some researching on the forums and come across your points for increasing security.

1. Split database with tables in one and forms/reports in the other.
2. Made the front end user database into an accdb to password the VBA.
3. I know that in Access '07 you can click the Microsoft button (4 squares top left corner) and go into Access Options. From there you can disable special keys, disable navigation pane, and remove views. My only problem with this is the user going in a clicking them back. If they know about the shift key they should have knowledge of were the other options are.

I know you can also code for removing certain special keys such as the shift key. I was more curious about using VBA to prevent users from accessing certain items. So if you set up a db with User/UserPass/UserLevel (1-Admin, 2-User as example) based on when they sign in certain things are blocked.

Is there a way to block using Access Options for Current Database?
This would help because then the user can't use the navigation pane. So I'd log in as the admin and be able to access it if needed.

 

[ghudson]

Is there a way to block using Access Options for Current Database?
This would help because then the user can't use the navigation pane. So I'd log in as the admin and be able to access it if needed.

Searching for "disable shift key" will lead you to Ricky Hicks ByPass Shift Key Utility that works for Access 2000, 2002, 2003 and 2007. Once you deselect the options in the current database that you do not want the user to access they will not be able to use them or change their settings if you have disabled the shift key property.

 

[Khalid_Afridi]

2. Made the front end user database into an accdb to password the VBA.

you should make your front end as accde before distributing to the end-users.
accdb is the source database where users can go to design of your form and your VBA code modules.
you should prevent the users to see your codes and modify it or form design with following steps to make your front end as secured and locked:

• (Access 2007)
  Compile your codes - debug menu at code window
  Compact and repair - Office button - Manage - Compact and Repair
  Make ACCDE File Format - Database Tools menu - Make ACCDE

These steps will lock your codes from being modified or watched.
you should make a backup copy before going through all these steps.

Good Luck!