Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access protection

ResolvedVersion 2003

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.