By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

Access 2003 Security

P: 6
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.
Oct 24 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,347
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...
Oct 24 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Check this website out. It's very good.

http://www.jmwild.com/Accesssecurity.htm
Oct 25 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.