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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question