How to protect tables in Access 2010?

hannlapp

Registered User.
Local time
Today, 22:20
Joined
Sep 22, 2011
Messages
12
Hi!

I undestood that there is not anymore mdw-file in access accdb-format. Iif ten users use my access table and I do not want three of them to delete records from these tables, so how can i prevent them to do it?

Thanks for answers
 
You can maintain the security that existed in the earlier versions of Access prior to 2007 if you do not convert the .mdb files to the new format.

If you have a requirement to convert to the new format then you will have to create and manage your own security model using some sort of login or validation.

As a side note to your question; It is now clear from your post but it would seem that you might be allowing users to interact directly with the tables. If this is the case, I would strongly suggest that you design a form through which you users would mange the data in the tables.

Hope this helps.
 

Users who are viewing this thread

Back
Top Bottom