Home All Groups Group Topic Archive Search About

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

Author
26 Jun 2009 5:36 PM
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

Author
28 Jun 2009 2:29 AM
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
Show quoteHide quote
"Jason" <Ja***@discussions.microsoft.com> wrote in message
news:85250846-CAF7-4C26-935B-BA5BB96F38AF@microsoft.com...
>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