can I password protect an access table but not the database?

  • Thread starter Thread starter db
  • Start date Start date
D

db

I need to have a database with only one table protected. I will access the
protected table through ADO and will be able to put the password in a
hardware key, but I would like to be able to let users open the database and
do whatever they like with everything except the one table
 
Configure all the tables with read-write permission for the Admin
user. Deny read permission to your special table to the Admin user and
the Users group. That locks them out. (Ensure that Admin is NOT the
owner of the database.)

Create a special user in a special workgroup file. Provide read-write
permission for that user to your special table. Log onto Access using
the special workgroup file and the special user.

I have a document in the website in my signature for additional
security information.


I need to have a database with only one table protected. I will access the
protected table through ADO and will be able to put the password in a
hardware key, but I would like to be able to let users open the database and
do whatever they like with everything except the one table
Click to expand...


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd
 
I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.
 
Back
Top