Question Database Restrictions Access 2007

[locksp]

Hi,

Still being a new to access, I am looking to restrict users from design and layout views with in a series of databases.

The databases will be maintained and any changes made by 2 administrators.

My requirement seems to be heading towards using users & permissions.
I have a very limited understanding of how this option works.

Looking at the wizard, it seems to be wanting to set up a workgroup file containing user names for admin & users. This I am happy with. My concern is; will creating and applying this file affect just the database I am working on or will it affect each users use of access in general?

I hope you can understand what I'm trying to ask.

Regards

Steve

 

[JamesMcS]

I think the workgroup info file is per-database so it shouldn't affect the users going into other databases.