Kevin has attended:
Access Intermediate course
Access protection
Can you protect a table in Access from certain users, so they can't change the data?
RE: Access protection
Hi Kevin
The way to protect a table from having the data changed by certain users is to set up user level security, so that all users need a password to access the database
Then you can set which objects the users can access and whether they can make changes.
Alternatively you can hide all the tables and have the users access them by clicking buttons on forms.
These buttons could run Macros that open the table as Read Only
Hope this helps
Carlos