Integrated Security with Access 2007

[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!

 

[Armen Stein]

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!

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

 

[David W. Fenton]

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.

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