Unset Password

[danaleblanc]

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.

 

[Autoeng]

What is the message displayed. Need more info to diagnois.

Autoeng

 

[danaleblanc]

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.

 

[Autoeng]

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

 

[danaleblanc]

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?

 

[ghudson]

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

 

[skinlab]

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?

 

[skinlab]

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.