Prevent changes to table layout by users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Back
Top