Access Logon Problems

[david smith]

We have an access database that was created by an employee who is no longer
here. THe database had tables that were linked to another database. The
password for the linked database was changed, which caused problems. When I
finally figured out what had happened, I reset the password on the linked
database, and that solved almost all of our problems except for one.

One employee is prompted for a userid and password, even though there are
none set up in the database. I have tried creating on for her, but even when
she uses that logon, she gets an error message saying it is not a valid
userid or password.

I want to be able to allow her to access the database and would like to
avoid the logon screen completely. I have cleared the password for the Admin
user, but that didn't help.

 

[Joan Wild]

That user's computer is joined by default to a workgroup file that has a
password set for the Admin user.

If she is using 2002 or 2003, just rename every mdw file you find on her
computer. When she opens Access again, it'll create a pristine copy of
system.mdw and let her in with no login dialog.