Application Security

[Dallas Miller]

I am setup security in an Access 2002 application and I
have a question about using the workgroup information
file for security. I would like the system to grab the
user's network id and look them up in the workgroup
information file and then grant them the appropriate
rights. This way they do not need to log onto the
application. Is this possible or is the second login the
only way?

Any help would be greatly appreciated.

Thanks,
Dallas Miller

 

[Joan Wild]

You can't integrate Windows security with Access security.

You can create the user in Access using the same username as their windows
login; but they'd still need to supply a password to get into Access.

If you have only one level of user permissions, you can secure Access
without requiring a login; however, it sounds as though you have more than
one group.