Password Protection, History

J

jonwongfanclub

Is there a way in MS Access to have users login to the program? Like
you could be a regular user who just searches for stuff, and then
moderators who are allowed to update the database and also have a
history of which person updated which fields in order to keep people
accountable from updating the database correctly? Thanks!
 
D

Dirk Goldgar

Is there a way in MS Access to have users login to the program? Like
you could be a regular user who just searches for stuff, and then
moderators who are allowed to update the database and also have a
history of which person updated which fields in order to keep people
accountable from updating the database correctly? Thanks!
Click to expand...

The standard way to do this is to implement user-level security. Then
you can define users and passwords for the database, classify users into
groups, assign different permissions to different groups (e.g.,
read-only users, update users, adminstrators), and use the CurrentUser()
function to capture the current user's ID.
 
J

John Vinson

Is there a way in MS Access to have users login to the program? Like
you could be a regular user who just searches for stuff, and then
moderators who are allowed to update the database and also have a
history of which person updated which fields in order to keep people
accountable from updating the database correctly? Thanks!
Click to expand...

Yes, it's called Workgroup Security. It's pretty powerful (it can
easily do all you describe), fairly difficult (although not
impossible) to break, and pretty demanding to implement. Get a copy of
the Security Whitepaper:

http://support.microsoft.com/?kbid=207793

Print it out.
Read it... carefully.
Get a good night's sleep.
Read it... carefully. AGAIN.
Follow the instructions, *all* of them, step by step.

I've secured dozens of databases and I *still* leaf through my
dog-eared printout each time.

John W. Vinson[MVP]
 
Top