Access asking for a login and password

G

Guest

When I open any database from our server it asked for a username and
password, but there is no security on any databases on any of the network
drives. How do I get this version of access to stop doing this? I use Access
XP
 
R

Rick Brandt

Cam said:
When I open any database from our server it asked for a username and
password, but there is no security on any databases on any of the
network drives. How do I get this version of access to stop doing
this? I use Access XP

Whether you are prompted for a UserName and Password has nothing to do with what
file you are opening. It has to do with the workgroup file (mdw) being used by
the Access session. If that workgroup has a Password assigned to the default
user account "Admin" then you are prompted. If it does not have a Password
assigned then you are not prompted.

Somewhere along the line your default workgroup was changed to one that has a
Password on the Admin user. You need to either clear that Password or join a
different workgroup where that user has no Password assigned.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top