how do you set pass.& users in access,so only the Admin.can modify

B

Baim

I have created a database, and now I would like to add some users, who have
the ability to only read, and add stuff to the database, but not to delete,
or to modify any tables, queries, or anything else. Also, they should not be
able to see the tbles at all. All they neeed to get, is the opening switch
board. I want the Administrator (me) to be the only one with the rights to
modify stuff.
Thank you in advance.
Ib
 
J

Joan Wild

Baim said:
I have created a database, and now I would like to add some users,
who have the ability to only read, and add stuff to the database, but
not to delete, or to modify any tables, queries, or anything else.
Also, they should not be able to see the tbles at all. All they neeed
to get, is the opening switch board. I want the Administrator (me) to
be the only one with the rights to modify stuff.
Click to expand...

You can accomplish this by implementing the user level security in Access.
It isn't trivial, so take the study and understand it and practice on a copy
of your database.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm
 
Top