Prevent changes to table layout by users

C

ceruleanhl

How do I prevent changes to a table layout by users, assuming I'm the
Database Administrator? (I.e., prevent them from hiding or unhiding columns).

I want users to be able to change table data only by using a Form I created,
and not by manually keying in the data in the tables which are affected. I
can control which forms they can open and close, but this is meaningless if I
they can open the tables whose data the forms modifies.
 
J

Jack MacDonald

You must implement Read With Owners Permission (RWOP) queries. They
allow you to deny permission for users to access the tables directly,
but instead must work through your queries. They are explained in the
Security FAQ -- see the website in my signature for a link.

How do I prevent changes to a table layout by users, assuming I'm the
Database Administrator? (I.e., prevent them from hiding or unhiding columns).

I want users to be able to change table data only by using a Form I created,
and not by manually keying in the data in the tables which are affected. I
can control which forms they can open and close, but this is meaningless if I
they can open the tables whose data the forms modifies.
Click to expand...


**********************
[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Top