Password Prompt opening any DB

[George Wilson]

I am assisting a customer using Access 2000 on Windows
2000 environment. He does not remember what he did but
when ever he opens any database he is prompted for a
username and password. The user name is edna (not sure how
he did this) and the password is blank, hit OK and you go
right into the Database. It looks like there is an edna
added as a user somehow but I'm unable to remove the user
and stop the prompt. I have been unable to find much help
info withing Access or the Microsoft site, does anyone
know what needs to be done to prevent the contstant
prompting any time he opens a DB?
TIA
George

 

[Scott McDaniel]

Your customer needs to find and re-join the "system.mdw" workgroup file ...
I'm betting someone was playing around with Access User Level Security and
created and joined a different workgroup.

Use file search to find "system.mdw" and "wrkgadm.exe" (which is the
workgroup Administrator). After finding both, run wrkgadm.exe and join the
system.mdw workgroup file.

More info re: ULS:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

 

[Guest]

In the system.mdw workgroup file on his PC, if "edna" got
put into the admins group, and the user "admin" was
removed from it, that might cause edna to become the
default user. Who knows what else is up? I screwed up my
system.mdw file in a similar way the other day. I just
wanted to put it back to the Access default and there
were way too many things I'd done to it (thought I was
working on a custom security file), so I fixed it by
cheating: I went to another PC with the same version of
Access, located and copied the system.mdw file under
Office, and copied it onto my computer over the screwy
one. Solved the problem, anyway.

Helen

 

[Scott McDaniel]

If you use Access 2000 or greater, you can simply delete the system.mdw.
Access will dutifully re-create it you!!