Access 2007 - Different Switchboard Forms for Different Users

[Jen]

I designed a database in 2003, with different user groups - mainly
administrators and staff. The administrators need different types of
forms as opposed to the staff. On login, I had a form called switch
open the correct Main Switchboard form for that type of user.

When trying to open the database in 2007, it just opens the switch form
and doesn't go anywhere from that. Is there any way to bring up
different main switchboards for 2 different types of users?

 

[Brendan Reynolds]

Have you converted the app to the new file format? (User-level security is
not supported with the new file format). Have you enabled the app or placed
it in a trusted location? (By default, VBA code will not run if the app is
not in a trusted location).

 

[Jen]

No, the file is still 2003. I used the code to set the workgroup
file. I think possibly you're right about being in a trusted
location, because we were just enabling the content, didn't add it as
trusted. Will try that

Thanks