Different switchboards for different users?

[Chris Burnette]

Question: Is there a way to define a different default switchboard
depending on which user is logged in? Our company has multiple departments,
and we want each department to have their own menu available at startup.
Does anyone know of a way to do this?

Any input is appreciated.

Thanks,

Chris

 

[Joan Wild]

Hi Chris,

I would recommend that you create your own 'switchboard' forms and not use
the switchboard manager.

When you open your database you can determine who the current user is via
the CurrentUser() function and then open the appropriate form. That's
assuming you are using Access user level security. And if so, you can
simplify it by determining if the current user is a member of a certain
group (function is in the security FAQ
http://support.microsoft.com/?id=207793 ).

If you aren't using the user level security, you can grab the windows
username using the function available at
http://www.mvps.org/access/api/api0008.htm and open the appropriate form.

 

[Chris Burnette]

Thanks Joan. I tried your second option, grabbing the Windows username.
However, this code doesn't seem to be working quite like I expected it to.

Rather than returning my Windows username or even my network name, it
returns the string "Database". I checked the .dll file that the program is
pulling data from, and it does indeed have a "Database" string in it, but I
don't quite understand why it is pulling that particular string.

If anyone could lend some insight into why this function
(http://www.mvps.org/access/api/api0008.htm ) is returning this particular
string, I would appreciate it.

Thanks,

Chris