Retrieving Log-in Information in a Secure DB

[mishbaker]

If I secure a database and a user does his login, how can I retrieve his User Level (i.e. Admin, Guest, SuperUser, Chump, etc) to restrict the viewing of certain controls on my Main Menu?



All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[FancyPrairie]

Check out this thread thread702-942221

 

[DougStevens]

The CurrentUser() function will return a string of the user's login name.

You can declare a WorkSpace variable to get to the "Users" and "Groups" collections.

First set the WorkSpace variable to "DBEngine.WorkSpaces(0)".