Bypassing the Workgroup file and taking the USer Id from Windows Login Id

[KK]

Hi,

I have an application which uses the workgroup file to set the access
permissions on the MDB. Now, as we want to store the User Ids in a
centralized location, we wish to have the User Ids taken from the
Windows Logon. The User Ids will be <DOMAIN>\<USER ID>. This way the
Users need not have different set of security options on different
applications, thereby all the applications used in the company have a
centralized security mechanism.

Now, my doubt is, whether we have a way in MS -Access to call the
function in a security dll (written in .NET) and depending on the
permissions that the User has, allow him to make modifications to the
code. [The application level security like which screen has to be
displayed to the user is coded in the application)

Any code snippets with the solution will be a plus.

Thanks in advance

KK

 

[Joan Wild]

Hi,

I have an application which uses the workgroup file to set the access
permissions on the MDB. Now, as we want to store the User Ids in a
centralized location, we wish to have the User Ids taken from the
Windows Logon. The User Ids will be <DOMAIN>\<USER ID>. This way the
Users need not have different set of security options on different
applications, thereby all the applications used in the company have a
centralized security mechanism.

Perhaps you can adapt the code here
http://www.mvps.org/access/api/api0008.htm