How to secure database in access 2007

[Daoud Fakhry]

Hi all,
I am using access 2007 and created a database. I changed my file to MDE and
disabled some options using the access option. Now the database runs directly
the switchboard and I added some bottuns in my switch board which linked to
the forms where the users can enter data.

some of the users finally know that if they hit the shift key while running
the database they will be able to view the tables, queries and apply some
changes in the database. Is there any other way in access 2007 so I can
assign permissions and limit the users accessability to the database.

Also, as I created ACCDE file, is my ACCDE file is the main file now or
ACCDB? which one should be used in the share drive by users.

Thanks for your help in advance.

 

[box2003]

In previous Access versions 2003 and back, you should be able to implement
the shift bypass features to slow them down a little more.

If you access the article at the below URL, you will understand the process.

http://www.databasedev.co.uk/disable_shift_bypass.html