I have two databases and set a password on one of them. When I attempted to
open the other one (they are both on my desktop), I had to enter the same
password that I set on the first one. I never opened the second one to set
security as it is not a database on which security is needed.
Any ideas on what occurred and how to fix it? I have attempted to undue an
unset password with no success.
Thanks,
Are you prompted for just a password, or for a username and password?
Likely the latter, in which case you are joined by default to your secure mdw. Use the workgroup administrator to rejoin system.mdw

Signature
Joan Wild
Microsoft Access MVP
:I have two databases and set a password on one of them. When I attempted to
: open the other one (they are both on my desktop), I had to enter the same
[quoted text clipped - 5 lines]
:
: Thanks,
Londa Sue - 15 May 2008 22:22 GMT
It was prompting me for a password. Admin was the default user. I did a few
things after joining the system.mdw, and now it works.
Thanks,
> Are you prompted for just a password, or for a username and password?
>
[quoted text clipped - 9 lines]
> :
> : Thanks,