ACC2000: Workgroup Information File Is Reset to Default System.mdw After Self-Registration

ID: Q241230

The information in this article applies to:

Microsoft Access versions 2000, 97

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

On a computer on which you have installed both Microsoft Access 97 and Microsoft Access 2000, you find that one or both versions of Access are using the wrong workgroup information file (default name, System.mdw). This change can cause one of the following symptoms.

NOTE: You notice these symptoms when there has been a change in security.

You are no longer prompted to log on when you open your Access databases.
You are prompted to log on, but the account or password that you type does not work.
You can open your databases with the usual logon name and password, but the security options for the account have changed.
You see the following message:

Microsoft Access couldn't find the file '<Windows\System folder>\SYSTEM.MDW'. This file is required for startup.

CAUSE

You have, at some point, defined a workgroup information file that does not have the name System.mdw, or that is not in the same location as it was when you first installed Access.

RESOLUTION

Create a shortcut to Access that includes the /wrkgrp switch and path to the workgroup information file. This forces Access to always use the same workgroup information file and to ignore the registry setting. The following is an example command line that you can write in the shortcut to indicate that Access must always use the workgroup information file, C:\Secure.mdw:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /wrkgrp "C:\Secure.mdw"

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Problem

On a clean computer (a computer that has a newly installed version of Windows, and no other applications), install Access 97. Do not install Access 97 into the default folder. Instead, install it into a folder named C:\Acc97. This is to avoid installing Access 97 and Access 2000 into the same folder. Accept all other defaults during Setup.

On the same computer, install Access 2000, and accept all the defaults.

IMPORTANT: During Setup of Access 2000, do not allow Setup to upgrade Access 97. This is to make sure that Access 97 remains installed.

After Access 2000 is installed, locate the following folder:

C:\Program Files\Microsoft Office\Office\1033

Click the Workgroup Administrator (Wrkgadm.exe) in the folder, and create a new System.mdw at the following location:

C:\System.mdw

Start Access 2000.

On the Tools menu, point to Security, and then click User and Group Accounts.

In the User and Group Accounts dialog box, click the Change Logon Password tab.

Give the Admin account the password Test, and then click OK.

Quit Access 2000.

Restart Access 2000 and open the sample database Northwind.mdb. Note that you are now prompted to log on.

Quit Access 2000.

Start Access 97.

Quit Access 97.

Start Access 2000 again.

Note that you receive the following message from the Windows Installer:

Please wait while Windows configures Microsoft Access 2000.

After Access 2000 opens, try again to open the Northwind database. Note that the database opens without asking you for a password.

Press CTRL+G to open the Immediate window.

In the Immediate window, type the following, and then press ENTER:

?DBEngine.SystemDB

Note that the result of this code indicates that the System.mdw is now back to its default location of C:\Program Files\Microsoft Office\Office\System.mdw. This is the location of the System.mdw determined by Setup when you first installed Access 2000.

Explanation of Behavior

When you run Access 97, Access 97 reregisters itself and makes itself the current version of Access on the computer; this means that at this point, if you click on an Access database, Access 97 tries to open the database. Likewise, when you run Access 2000 after running Access 97, Access 2000 reregisters itself, and makes itself the current version. When Access 2000 reregisters, Access 2000 also rewrites the System.mdw location to the Windows registry. The location written to the registry is always the location determined when Access was first installed on the computer. If Access 97 does not find the System.mdw location there, Access 97 displays a message that the System.mdw could not be found. If Access 2000 does not find the System.mdw location there, Access 2000 starts the repair process to create a default System.mdw with no security defined.

The following is an example of the registry keys that are rewritten when Access self-registers.

Access 97:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Jet\3.5\Engines

Name = SystemDB
Data = <path of Windows\System folder>\System.mdw

Access 2000:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Access\Jet\4.0\Engines

Name = SystemDB
Data = <path you defined during Setup>\System.mdw

NOTE: You do not notice this problem on a computer running both Access 97 and Access 95 because Access 95 does not reregister and make itself the current version of Access. In this configuration, Access 97 is always the current version of Access.

REFERENCES

For information about another issue when using a shortcut to open an Access 2000 database, please see the following article in the Microsoft Knowledge Base:

Q238258 ACC2000: Record-Level Locking Not Used with Windows Shortcut

For more information about the Workgroup Administrator program, click Microsoft Access Help on the Help menu, type work with a workgroup information file in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: pra

Keywords : kbdta
Version : WINDOWS:2000,97
Platform : WINDOWS
Issue type : kbbug