Access 2003 Security

[mbsevans]

New user here.
I have constructed a database to track basic employee information.
I wish to place finished database on a the network.
I need to obviously retain full admin persmissions for all aspects of the database.
More importantly I need to allow one clerical user to enter data and thats it.
Now...I have been through various explanations of how to set this up but none of it is making sense to me.
Even the Access 2003 security wizard is great, but...I am obviously missing something.
Does anyone have a laymans version of how to do this?
Thanks in advance.

[NeoPa]

From Tools / Security there are options to set up Users; Groups and also to assign permissions for each object (query; table; etc.) to said users and / or groups.
It's important to set the permissions on the <New ...> item in each list - as this will save you the trouble of going around afterwards and setting the permissions after you've created a new object.

NB. Very important to know.
By default, Access is set up to use the user Admin as standard without a password.
If you want to control the security you must apply your user security database (normally SYSTEM.MDW) to all users who will be using your project. This is done using the 'Workgroup Administrator'. I'm afraid none of this is very Administrator friendly. You can remove the Admin account or apply a password. Bear in mind though, a canny user will know that to use the Admin account without knowing the password simply involves replacing your SYSTEM.MDW with the default. Lots to bear in mind and, frankly, not much fun - but you did ask...

[MMcCarthy]

Check this website out. It's very good.

http://www.jmwild.com/Accesssecurity.htm