Password Protect a Table?

hi,

Is it possible to password Protect a table in Access 97?

I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how.

any ideas?

You'd need to use Access Security to do this - there are loads of posts on the subject of security if you search.

just been looking at the security section. unfortunately i cant use user groups to set access rights as all users have admin access.

i have created a database for the company but need to make sure none of the other users can go into the datasheet view of the table.

is there a way to create a simple popup to ask for a password if someone tries to open the datasheet view of the table??

is there a way to create a simple popup to ask for a password if someone tries to open the datasheet view of the table??

Click to expand...

More than one answer:

1. In general, NO, because no events fire from the Access database panes. No events = no popups.

2. In certain cases, YES, if you take the trouble in advance to build your application a certain way.

2.a If you wish to allow users only restricted access to certain data elements, you cannot let them see the DB window. So you build a switchboard form, hide the DB window from them forever, and build buttons to open queries or tables that users are allowed to see. You have to look up ways to prevent users from bypassing startup forms and the like. This forum has discussed the issue many times. Anyway, once you do this, put code behind the queries or tables to test security for you on the button click events. Password popups or whatever else you want.

2.b If you wish to allow users to see the DB window, you have to make the table owned by some arbitrary user (you, e.g.) and give no one else any access to it. (It is one of the very rare cases where I would suggest that an object have permissions by user rather than by group.)

Now set up queries with specific access permissions for groups and set the query to run as ByOwner for the table that gets opened. ByOwner is a Help Topic. When you do a ByOwner query, the table is owned by a different user than the person using the query, but the query ACTS as though it was the table owner. You then have to

2.b.1 set permissions on the query to restrict who can open the query, either by user or by group (with group as "preferred" method).

and

2.b.2 set properties of the query as to what it will allow to be done through itself, like "no update" or "no insert" or whatever.