Security and user roles in access 2007

[Jack_Maloney]

Hi,

I've just finished creating my first database in Access 2007 and to finish it off I just want to add some user security. For example I want 3 different types of user - an admin, someone who can edit data and a read-only access user.

I thought this would be relatively simple to do. However, a search on the internet has informed me that access 2007 does not support user groups. This seems ridiculous to me and wondered if anyone knew of a way around this?

Please help!!

 

[boblarson]

If you are using the newer ACCDB file format you will have to build in your own security as the User Level Security has been removed from the newer versions. If you are using the older MDB format you can still use Access User Level Security with that format.