locked out of all DB's by password

[Darren Humphries]

Hi all,

I'm hoping someone can help me with this. I can't figure out what is
going on here.

Using Win2K and Access 2K

I had created a database and password protected it so I could test
syncing with a PPC. When I was done testing I deleted the database.

Today I went to open a database that is not password protected and it
prompts me for the password. ?? I think I know the password but it also
asks for a user name. I can't seem to figure out the right combination
to put it.

Because of this, I can't open ANY databases and can't even create a new
one. I am locked out of ALL. Grrrr...

Is there a way to fix this, even if that means playing with the
registry? Anyone have any ideas?

Thanks for any help.

Darren

 

[Joan Wild]

Your screwed. Better off creating a whole new database.

 

[Joan Wild]

Hi Darren,

Using Win2K and Access 2K

I had created a database and password protected it so I could test
syncing with a PPC. When I was done testing I deleted the database.

Do you mean you put a database password on it; or did you implement
Username/password security (not the same thing)

Today I went to open a database that is not password protected and it
prompts me for the password. ?? I think I know the password but it also
asks for a user name. I can't seem to figure out the right combination
to put it.

That suggests you are joined to a workgroup file (i.e. you implemented
username/password security yesterday).

Because of this, I can't open ANY databases and can't even create a new
one. I am locked out of ALL. Grrrr...

Locate all *.mdw files on your computer. Use Start, Run, wrkgadm.exe

This will start the workgroup administrator and it will tell you the
workgroup you are currently joined to by default. You want to click Join
and rejoin the standard system.mdw that ships with Access. System.mdw is
usually located in the windows system folder, but try joining any of the
other mdw files you found above.

Once you rejoin it, you shouldn't be prompted for a username/password.

 

[Darren Humphries]

Thanks Joan. Your second response was a little more informative than
your first.

Actually, someone suggested to me that I just get the setup.mdw (I think
that was it) file from another computer and overwrite my own.

That did the trick.

Thanks again Joan.

Darren

 

[Clare]

Darren

Did you manage to get this sorted as I am having the same
problem.

Would appreciate any help that you could give me.

Clare

 

[Joan Wild]

Thanks Joan. Your second response was a little more informative than
your first.

For the record, that first response was not from me. If you are using a
newsreader to read the news, you can check the headers and see it did not
come from the same source as say, this message.

 

[Arlen Besel]

Darren,
I have a similar problem. Actually I had not used Access
and when I try to open it or a new file it puts up a
window with a user name and asks for a password. I did
not set one and have been unable to get it running. Did
you get any help with this problem? I don't see a way out
unless I must reinstall Access. Can you help?
(e-mail address removed)

 

[Joan Wild]

Hi Arlen,

You are joined to a workgroup file that has a password set on the default
Admin user.

You don't mention what version of Access, but

Locate all *.mdw files on your computer.

Then use the workgroup administrator (in 97/2000 Start, Run, wrkgadm.exe).
If you are using 2002 or higher, you can cancel the login screen, and use
Tools, Security, Workgroup Administrator. This will open a dialog showing
you the current mdw you are joined to.

Click Join and rejoin the standard system.mdw that ships with Access.
System.mdw is
usually located in the windows system folder, but try joining any of the
other mdw files you found above.

If you found only one mdw file, then try copying system.mdw from another
computer.