Integrated Security with Access 2007

  • Thread starter Thread starter DotNet_Coder
  • Start date Start date
D

DotNet_Coder

Is there a way to capture and use the Windows login to control what
can be accessed in an Access 2007 database? If so, can you please post
how this would be done? Thank you very much!
 
Is there a way to capture and use the Windows login to control what
can be accessed in an Access 2007 database? If so, can you please post
how this would be done? Thank you very much!
Click to expand...

You can get the Windows login a couple of ways. See the discussion at
http://social.msdn.microsoft.com/Forums/en/isvvba/thread/a978fc57-88a2-49d2-89a9-ba645e1f5651
for a start.

However, getting it is the easy part. There's no built-in security
model that uses Windows logins to control permissions in Access. You
would need to do that using a table of Users and maintain and control
their permission levels yourself.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
There's no built-in security
model that uses Windows logins to control permissions in Access.
You would need to do that using a table of Users and maintain and
control their permission levels yourself.
Click to expand...

Or you could duplicate the Windows user logons in Jet ULS, which is
what I often do.
 
Back
Top