Limit user right on the DB

[Icy]

Hello, could anyone show me the best way and quick way to protect the Form
and fields at the Table from authorized change. I would like to put the
database on the share drive, so everyone can use it, but I don't want anyone
to go the edit mode or table to change anything. I try to hide the table and
put a password on the form, however, it's still too risky. User still can
unhidden the table and change the data without going through the Form. Any
assistance would be greatly appreciated.

 

[Rick Brandt]

Hello, could anyone show me the best way and quick way to protect the
Form and fields at the Table from authorized change. I would like to
put the database on the share drive, so everyone can use it, but I
don't want anyone to go the edit mode or table to change anything. I
try to hide the table and put a password on the form, however, it's
still too risky. User still can unhidden the table and change the
data without going through the Form. Any assistance would be greatly
appreciated.

For Forms, Reports, and code Modules use an MDE instead fo an MDB.

As for the data I will state my usual... If you need to protect data from
non-users of the app use network security. If you need to protect data from
users of the app then don't store it in an MDB file. As long as you do, you can
only erect barriers. You cannot absolutely prevent tampering by a sufficiently
knowledgable and persistent user.