Security basics???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Do do I have this concept right? When you secure a DB, Access creates a mdw
file that acts as a gate keeper for the DB. The user enters the db by
'accessing' the mdw file? or directly through the mdb file? I'm not sure
what the whole relationship is.

I've tried to create a secure DB and totally messed it up, even after
following the Step-by-Step instructions for Acces 2003. Maybe I'm too dumb
to figure it out.
 
Do do I have this concept right? When you secure a DB, Access creates a mdw
file that acts as a gate keeper for the DB. The user enters the db by
'accessing' the mdw file? or directly through the mdb file? I'm not sure
what the whole relationship is.
Click to expand...

The MDW file contains an encrypted list of all of the users and groups, and
the users' passwords. The database itself defines the user privileges - so if
the mdw file contains a user "jvinson" in the "Powerless Users Group", you can
specify that the Powerless Users Group can open two forms in read-only view
and nothing else, and I'd be stuck doing just that.
I've tried to create a secure DB and totally messed it up, even after
following the Step-by-Step instructions for Acces 2003. Maybe I'm too dumb
to figure it out.
Click to expand...

Don't beat up on yourself. Security is VERY complicated and tricky. I still
(after years of working with it) print out the security FAQ and check off
steps with a highlighter pen.

Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

John W. Vinson [MVP]
 
Back
Top