Front End, Back End?

  • Thread starter Thread starter Ant
  • Start date Start date
A

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
 
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
 
Ant said:
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.
Click to expand...


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
 
Back
Top