Unset Password

danaleblanc

Registered User.
Local time
Today, 05:16
Joined
Jun 13, 2001
Messages
41
An Access 2000 user has unknowingly put a password in Access that will not allow her to open Access (the program not a database). I am not able to guide her in the right direction, hope someone on-line can.
:confused:
 
What is the message displayed. Need more info to diagnois.

Autoeng
 
She says it ask her to log in and a password. She is not aware of a log in name or a password. This all happens when she tries to open Access. Hope that is what your asking for.
Thanks for your time.
 
Most people don't realize that Access databases are ALWAYS secured. Access installs with a default workgroup file named System.mdw. It registers this default in the Registry and Access assumes that this is the workgroup you want to join when you open what you think of as an "unsecured" Access db and joins you to that workgroup as the admin user giving you all rights to the db. That makes the security transparent.

Apparently, your user has recently used a "secured" db. When you use the workgroup administrator to specifically join a workgroup, Access replaces the default workgroup name in the Registry with the one you just joined. Therefore, until you specifically join a different workgroup, the last one you joined now remains as your default workgroup. To get back to what looks like "unsecured" mode, have your user specifically join System.mdw.

This isn't surefire since many people also make the mistake of modifying System.mdw especially when they are playing around with security to learn how it works. We get many posts here from people who have done this. So if rejoining System.mdw does not resolve the problem, you'll need to get a clean copy of System.mdw and copy it to the correct directory on her PC. Be very carefule with this since each version of Access uses the same name for this workgroup file but they are stored in different directories. Make sure you get a copy of the correct version and that you install it in the correct directory.

To avoid this problem in the future when working with "secured" databases, make a shortcut to open the db and use the workgroup parameter to pass along the workgroup name. This method of opening a secured db does NOT modify the Registry so it won't leave you with a different default workgroup.
 
An excellent explanation Pat.

To specifically join a workgroup you need to run the work group administrator by locating and double clicking the file Wrkgadm.exe. In the Workgroup Administrator dialog box, click Join.

Type the path and name of the workgroup information file that defines the Microsoft Access workgroup you want to join, and then click OK, or click Browse and then use the Select Workgroup Information File dialog box to locate the workgroup information file.
The next time you start Microsoft Access, it uses the user and group accounts and passwords stored in the workgroup information file for the workgroup you joined.

Autoeng
 
We followed your steps to "unsecured" her database. Her path said system.mdw, so we are about to get a clean copy of system.mdw and copy it to the correct directory. I want to make sure we are putting this in the right place. Can you guide me in the right direction?
 
The System.mdw file goes in the '\Windows\System\' directory which varies depending on your version of Windows.

Windows 9x = C:\Windows\System\
Windows XP = C:\Windows\System32\

But again it varies on where your systems folks installed Windows and the version of Windows your computer is using.

Also, you should be able to copy an unaltered System.mdw file from a computer that is using the same version of Windows and Access to the "infected" computer and rejoin the computer to the 'clean' System.mdw file. Verifying the modified date will also tell you when the System.mdw file was last altered (installed).

HTH
 
so what your saying is i cant setup user accounts for my access database just inside that particular database, i have to create an associated 'workgroup file' that i would need to distribute WITH my database?

All i want is an admin account for my vb program to use
and a read only account for them to use in mail merge etc

now how do i do that?
 
Create a workgroup file and establish the permissions that you want. Distribute the workgroup file with the application db. Attempting to use system.mdw will only cause problems. You will still need to distribute it with your app, and it would cause confusion on their system because your workgroup would have the same name as the default workgroup.
 
Pat Hartman said:
Create a workgroup file and establish the permissions that you want. Distribute the workgroup file with the application db. Attempting to use system.mdw will only cause problems. You will still need to distribute it with your app, and it would cause confusion on their system because your workgroup would have the same name as the default workgroup.

i c, well about 5 unopenable databases later, i finally have a tidy database with 3 accounts admin (cant remove it!?) administrator (owns everything) and Ronly part of the ReadOnly group.

but much to my dismay, word2000 cant get its head around mail merging with a database that has user accounts on it.
 

Users who are viewing this thread

Back
Top Bottom