Security – Multi User (Access 2000)

Topic

New Reply

I have a database with many users. I have locked down the tables in the security settings (set the admin setting) to only adding data. I have a small group of people that need to make changes to the data (about once a month) but other than that the tables are locked down. Unfortunately, those that unlock the security settings to make changes forget to lock it back up then I have a mess and have to restore the whole thing, losing a lot of information and having to have them re enter data. Is there a way to have the tables locked down (by this, I mean only adding data, no changes or deletions allowed) every time someone opens the database. This should take care of the problem, as it would be “relocked” automatically. Any other suggestions would be great. I really don’t want to set passwords or make users, as that is such a pain!!
I am definately not an expert at this stuff… and can’t write code, but have a little knowledge and am easily coached.

Reply | Quote

Replies

You are going about this the wrong way. Instead of changing the settings, you need to have different security permissions for different groups. Then have the users that need to edit the data log in as members of the group that has those permissions. Did you apply Access security and remove the permissions from the Admin user? Moderator WendellB has a security tutorial on his website at http://www.access-experts.com[/url%5D that might be of help to you.

Reply | Quote

I never went through the wizard to do the security. Just set the user (admin) permissions. then when they needed to change the data, i had them change the permissions to administer. In the perfect world, they go back and change them back to “lock it down” but they are forgetting to do that, subsequently leaving it open and names and data is being changed all over the place (and whats worse is there is no real easy way to tell what/who)
If you can do some hand holding, i would be thrilled to have some help and get this cleaned up.
i always thought that the database defaulted to the administrator, so tahts why i did it this way.

Reply | Quote

It does default to Admin, but personally I think it’s a BAD idea to have your users go in and change permissions themselves… It leads to…… well… exactly what’s happening to you now…

Check out Wendell’s tutorial that Charlotte mentioned… It’s a great place to start… We can hold your hand as you have questions after that…

Reply | Quote

Ok. I have read the part about security and am still lost. HELPPPPPPPPPPP
I feel totally pathetic. I too think it is a bad idea, but you should have seen what we started with.
I can’t figure out how to change to the user. i did set up a person (that will have admin permissions?) I really need some help here… and

Reply | Quote

I recommend that you download and study the Security FAQ from Microsoft. It is the first link in WendellB’s tutorial, or go immediately to ACC2000: Microsoft Access Security FAQ Available in Download Center. It may take some time to digest, but it is a very useful and complete overview of user-level security.

Reply | Quote

I recommend that you download and study the Security FAQ from Microsoft. It is the first link in WendellB’s tutorial, or go immediately to ACC2000: Microsoft Access Security FAQ Available in Download Center. It may take some time to digest, but it is a very useful and complete overview of user-level security.

Reply | Quote

Ok. I have read the part about security and am still lost. HELPPPPPPPPPPP
I feel totally pathetic. I too think it is a bad idea, but you should have seen what we started with.
I can’t figure out how to change to the user. i did set up a person (that will have admin permissions?) I really need some help here… and

Reply | Quote

It does default to Admin, but personally I think it’s a BAD idea to have your users go in and change permissions themselves… It leads to…… well… exactly what’s happening to you now…

Check out Wendell’s tutorial that Charlotte mentioned… It’s a great place to start… We can hold your hand as you have questions after that…

Reply | Quote

I never went through the wizard to do the security. Just set the user (admin) permissions. then when they needed to change the data, i had them change the permissions to administer. In the perfect world, they go back and change them back to “lock it down” but they are forgetting to do that, subsequently leaving it open and names and data is being changed all over the place (and whats worse is there is no real easy way to tell what/who)
If you can do some hand holding, i would be thrilled to have some help and get this cleaned up.
i always thought that the database defaulted to the administrator, so tahts why i did it this way.

Reply | Quote

You are going about this the wrong way. Instead of changing the settings, you need to have different security permissions for different groups. Then have the users that need to edit the data log in as members of the group that has those permissions. Did you apply Access security and remove the permissions from the Admin user? Moderator WendellB has a security tutorial on his website at http://www.access-experts.com[/url%5D that might be of help to you.

Reply | Quote