How can I switch the current user from the default (Admin)?

[Jason]

I recently have switched to a new PC at the office, but with the new PC when
I access the MS Access database, it regards me as the default (Admin) user.
Formerly I had my own username and password. I can add my username to the
security list, but cannot get Access to prompt me to login as anyone other
than 'Admin'. Additionally there must be a way to change the current user in
Access but I cannot find the method.

Can anyone shed any insight?

Thanks so much

 

[Arvin Meyer MVP]

You need to join the proper workgroup to have Access recognize which user(s)
have access to the database. Because, you can get in so easily, it leads me
to believe that your database wasn't properly secured at all. Review the
security information below to make sure you are properly secured. Second,
the only way to change the current users is to close Access and restart,
then use the new credentials.

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm