Access 2000 and 2003 Security

[Anekwe]

I'm using Access 2003 on a server on a network with about 60 users. In one database, I want to restrict certain users to just read the tables and another group to update the tables and modify table design. As of now every user can update and modify table design. It looks like that they have full permission. I tried to go to Tools and then Security tab and use the Security Wizard to set up these permission groups, but it didn't seem to work when I tested different user accounts. Can someone suggest a solution so that I can lock down this Access database.

[ADezii]

I'm using Access 2003 on a server on a network with about 60 users. In one database, I want to restrict certain users to just read the tables and another group to update the tables and modify table design. As of now every user can update and modify table design. It looks like that they have full permission. I tried to go to Tools and then Security tab and use the Security Wizard to set up these permission groups, but it didn't seem to work when I tested different user accounts. Can someone suggest a solution so that I can lock down this Access database.

I am not by any stretch of the imagination an Access Security Expert, but it seems as though you have defined Group Accounts to accomplish you Security goals. If I remember correctly, Users within these Groups are also by design, members of the Users Group and as such will inherit the rights and privileges of being in the Users group (Least Restrictive Rule). Have you tried to remove privileges from the Users Group and reassign them to specific Groups which you have created? Again, I am not an expert in this area!

[NeoPa]

I'm using Access 2003 on a server on a network with about 60 users. In one database, I want to restrict certain users to just read the tables and another group to update the tables and modify table design. As of now every user can update and modify table design. It looks like that they have full permission. I tried to go to Tools and then Security tab and use the Security Wizard to set up these permission groups, but it didn't seem to work when I tested different user accounts. Can someone suggest a solution so that I can lock down this Access database.

You need to :

1. Assign all your users to groups.
2. Set up for each object, which groups have which rights to them.

Can be laborious but if that's what you need...
BTW Each PC needs to be set up (via Workgroup Administrator) to use your newly edited .Mdw file.
Also, each user will have to log on to Access each time it is opened.