Password tables

[tkacoo]

Is there a way to password protect a table? I protected
the form using an event procedure... but I would like to
protect the table too.

 

[Rick B]

In my opinion, you should not give your users access to the tables. If your
forms are based on queries that are run with the owner's permission and your
users have no direct permissions on the tables, then the users can only get
to the data through those forms.

Use the built-in security features of Access instead of creating methods to
apply passwords to individual objects.

Rick B


Is there a way to password protect a table? I protected
the form using an event procedure... but I would like to
protect the table too.

 

[John Vinson]

Is there a way to password protect a table? I protected
the form using an event procedure... but I would like to
protect the table too.

Download and print out the Access Security Whitepaper from
http://support.microsoft.com and read it carefully. Sleep on it. The
next day, read it carefully, *again*. Follow the instructions to
implement security on your database, step by step - it's very easy to
do it wrong!

Event procedure protection is *very* flimsy and easily bypassed.
Access security can be breached but it takes a knowledgable and
determined effort.