Domain Server and Access 97

[Soulbait]

Is there anyway for Access to use the domain server as its place to retrieve its list of users and groups for a secure database?

Thanks

 

[psemianonymous]

JET security doesn't really work with other types of security/logins. BUT you can make API calls and find out who is the current user, what is the current domain, etc.

Domain:

http://www.mvps.org/access/api/api0040.htm

Network username:

http://www.mvps.org/access/api/api0008.htm

I believe you can poll the environment variable "USERNAME" directly for the username also. --
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

 

[Soulbait]

Hey thanks for the info, Guess Ill just have to deal with the standard way

 

[psemianonymous]

There probably is *A* way to store all that on the domain server, but it won't prevent a user from holding SHIFT when opening the database and joyfully editing/deleting tables directly. JET security is the only way to do decent security in Access.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access