All databases including new ones require password!

  • Thread starter Thread starter BEP
  • Start date Start date
BEP said:
Reinstalling Access did not solve the problem either.

BEP
Click to expand...

Whether you are asked for a user name and password by Access is NOT determined
by which file you are opening. It is determined by which workgroup file is
being used by the Access session. If the workgroup being used has a password on
the default user "Admin" then you are prompted to log in. If it does not then
you are not prompted.

When you were messing with security you must have changed your default workgroup
file to one that has a password on the Admin user. You need to use the
workgroup administator utility to change your default back to System.mdw.

If you were foolish enough to apply a password to the Admin user in the
System.mdw workgroup file, then you have to log in with that password and then
clear the password once in. Otherwise you could delete that file and then open
Access without specifying any file. When it cannot locate System.mdw it will
create a new one. The new one will not have a password on the Admin user and
you would be back to normal.

Accesss User Level Security is an advanced topic and you cannot learn it or
apply it successfully by experimentation. You need to follow an explicit step
by step set of instructions to have any chance of getting it right. A search of
the web will turn up such documents easily.
 
Thanks. Removing the System.mdw file was exactly what I needed to do. And
I thought at the time that I was following explicit step by step
instructions that i found on the web.

Thanks again and I will be more careful in the future.
 
Back
Top