Security Users and Groups

[BillD]

Firstly, I do not use a password for my access database. I have an Access
database with about 10,000 records. It is split with a _fe linked to _be with
Tables. In the _fe and _be Database I go to Tools>Security>User and Group
Permissions. Under Permissions Tab in User/Group Name: is "Admin". Object
Name: "<Current Database>" List: is checked "Users" Object Type: "Database"
Permissions are checked "Open/Run" "Open Exclusive" and "Administer"
Should I have "Open Exclusive"' checked since there are 2 people using the
database.

Users: User Name "Admin".
Groups that User belongs to are"Admins" and Users"
Groups: Group Name "Admins" User that belongs to Group Admins is "Admin"
Group Name "Users" User that belongs to Group "Users" is "Admin".
I do not really understand the above and wonder if I have everything set so
that there is no security for Aministrator and Users. I do not need the
database to have any security.

Sorry if I have confused everyone. Fustrated.

Bill D

 

[Douglas J. Steele]

If you didn't do anything explicit to apply security, don't worry about it.

Unless you're being prompted to log into the application, the user will
always be identified as Admin, and the Admin user, by default, is members of
the two groups you listed.

 

[BillD]

Thats great news. Thanks so much for the review.

Bill D
Fredericton,NB