Password removal

[Guest]

Hi

I've somehow set up Access so that I have to give a
password each time I enter. The username and password are
not specific to a particular database but they happen each
time I try to open any database. I know what the password
is so I can get in to use the database but I haven't
worked out how to remove this password.
I would like it to be set up without any password.

Thanks in advance.

 

[Terry D]

Hi

I've somehow set up Access so that I have to give a
password each time I enter. The username and password are
not specific to a particular database but they happen each
time I try to open any database. I know what the password
is so I can get in to use the database but I haven't
worked out how to remove this password.
I would like it to be set up without any password.

Thanks in advance.

Select Open from the file menu. Locate the mdb file in the dialogue box &
highlight. Then select 'Open exclusive' in the drop down box. Enter the
password when requested. Then, under 'security', you'll then have the
option to unset the password.

Terry D.

 

[Roger Carlson]

Sounds like you have somehow set up Access Security, which is different than
a database password. The solution could vary depending on how you set it
up. Best bet is to get a copy of the Microsoft Security FAQ, which is the
bible for Access security. Read it through several times. It should help
you out. The FAQ can be found on the Microsoft site, but I also have a copy
on my website in the Knowledge Section:
http://www.rogersaccesslibrary.com/knowledge.html

 

[Joan Wild]

It would depend on what you did i.e. created a new workgroup file, or played
with the standard workgroup file.

Start by searching your computer for *.mdw files, and note their path(s).

Use the workgroup administrator (Tools, Security menu in 2002; Start, Run,
wrkgadm.exe in prior versions). It will show you the workgroup file you are
currently joined to by default. You see, Access uses a workgroup file every
time you open it (doesn't matter what database). It silently logs you in as
a user called 'Admin'.

When you implement security, you usually create a new mdw and set the
password for the Admin user, thus forcing the login dialog to display.

In the workgroup administrator, join one of the other mdw files that you
found on your computer (the standard one is named system.mdw and is usually,
but not always, located in the windows system folder). Once you join it,
you shouldn't be prompted for a username/password.

For your specific database where you want the login, create a desktop
shorcut to start it. You can use the /wrkgrp switch to specify a mdw to
use, and that will over-ride the default mdw for that session only. The
shortcut looks like:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

Finally, now that you are joined to the standard system.mdw, try opening
your secure mdb via a double-click in Windows Explorer. If you can even
open it, then it isn't secure, and you missed a step in the FAQ:
http://support.microsoft.com/?kbid=207793