security through vba (1 Viewer)

NightPort

Skizzy
Local time
Today, 03:53
Joined
Jun 1, 2001
Messages
27
Can I write code that tells Access to run as a certain user depending on the windows login? I know the API calls to get the Windows user name. Can I have it check and see if, for example, "Staff" is logged in to Windows, then run the DB as "Peon", and if "Admin" is logged in to Windows, then run DB as "DBA"?



:confused:
 

Users who are viewing this thread

Top Bottom