Limit user right on the DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Icy - 02 Dec 2007 16:06 GMT

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.

Reply to this Message

Rick Brandt - 02 Dec 2007 18:43 GMT

> 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
[quoted text clipped - 4 lines]
> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message