Front End, Back End?

[Ant]

Hi All,

I want to add security to my database that consists of a
front end and back end. If I add Users, groups, logons
etc. to the front end how will this carry over to the back
end which I also want to protect.

Thank You,

Ant

 

[Beth G]

Read teh FAQ on securing a database and I would suggest
using the help files and security wizard. Once you have
a workgroup created and have set up the users, you can
use this workgroup for any database. You should secure
both your front end and back end. Follow the steps in
the help and then repeat all but creating the workgroup
for your second database.

Beth G

 

[TC]

Hi All,

I want to add security to my database that consists of a
front end and back end. If I add Users, groups, logons
etc. to the front end how will this carry over to the back
end which I also want to protect.

Further to the other respondent's reply:

User and group definitions are stored in workgroup (MDW) files, not database
(MDB) files. When you start Access, it selects a particular workgroup file.
This defines the user names, group names, and user/group associations, that
are valid for that "run" of Access. When you open a database, Access looks
inside that database to see what permissions (if any) are assigned to those
user & group names for that database.

HTH,
TC