Locking Tables from being edited

[hycho]

Hi,

Does anyone know how to lock a table so that only certain users can edit a table in a particular database? As in, I can edit and change the records in the table, but everyone else has read-only access. I am using Access 2010, and don't know which drop down menu to start.

Thanks.

Hycho

 

[CJ_London]

Users should not be editing tables directly, only through the use of forms. You can then control access through the form.

If you have no security then users can still edit the tables but you can make it more difficult by putting them in a back end (so they can't edit the structure), use a password on the backend, hiding them and using the various options to limit user actions.

Search on this forum using 'secure a database' as a search string to find the many ways this can be done.

Here is another link that may help

http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552