ACC2: Errors After Reinstalling MS Access to Workstation

• Microsoft Access version 2.0

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

When you reinstall Microsoft Access to a workstation and then start Microsoft Access, you receive an error message similar to:

   Couldn't find file 'G:\ACCESS\SYSTEM.MDA'

   Tried to load module with duplicate procedure definition:
   doc_CleanObjTables

CAUSE

When you reinstall Microsoft Access to the workstation, incorrect settings are written to the MSACC20.INI file. For example, the line

   SystemDB=G:\ACCESS\WORKDIR\SYSTEM.MDA

   SystemDB=G:\ACCESS\SYSTEM.MDA

The [Libraries] section of the file might look like the following example before the reinstallation:

   [Libraries]
   G:\ACCESS\WORKDIR\wzLib.mda=rw
   G:\ACCESS\WORKDIR\wzTable.mda=rw
   G:\ACCESS\WORKDIR\wzQuery.mda=rw
   G:\ACCESS\WORKDIR\wzFrmRpt.mda=rw
   G:\ACCESS\WORKDIR\wzBldr.mda=rw

   [Libraries]
   G:\ACCESS\WORKDIR\wzLib.mda=rw
   G:\ACCESS\WORKDIR\wzTable.mda=rw
   G:\ACCESS\WORKDIR\wzQuery.mda=rw
   G:\ACCESS\WORKDIR\wzFrmRpt.mda=rw
   G:\ACCESS\WORKDIR\wzBldr.mda=rw
   wzLib.mda=rw
   wzTable.mda=rw
   wzQuery.mda=rw
   wzFrmFpt.mda=rw
   wzBldr.mda=rw

RESOLUTION

Make the following changes to the MSACC20.INI file:

1. Modify the SystemDB line in the [Options] section to point to the correct path for the SYSTEM.MDA file.

2. Delete the entries in the [Libraries] section that do not specify a full path.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

1. On a workstation running Microsoft Access, quit Microsoft Access and then make a backup copy of your MSACC20.INI file (for example, copy the file to MSACC20.SAV).

2. Double-click the MS Access Setup icon in your Microsoft Access program group, and then choose the Reinstall button.

3. After Setup is finished, open the MSACC20.INI file and note the incorrect settings in the [Options] and [Libraries] sections.

4. Either correct the MSACC20.INI file as described in the "Resolution" section above, or replace it with your backup copy.

REFERENCES

For more information about settings in the MSACC20.INI file, search for "MSACC20.INI," and then "Customizing MSACC20.INI Settings" using the Microsoft Access Help menu.