Microsoft KB Archive/120058

= ACC2: Errors After Reinstalling MS Access to Workstation =

Article ID: 120058

Article Last Modified on 11/6/2000

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q120058





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'

If you modify the MSACC20.INI file so that the SystemDB line in the [Options] section of the file points to the correct path for the SYSTEM.MDA file and then start Microsoft Access, you receive the following error message repeatedly while the Add-ins are being loaded:

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

is changed to:

  SystemDB=G:\ACCESS\SYSTEM.MDA

Note that the WORKDIR subdirectory is missing from the path for the SYSTEM.MDA file after the reinstallation.

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

After the reinstallation, the [Libraries] section might look like:

  [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

Note that duplicate entries that do not have a path are listed in the [Libraries] section after the reinstallation.



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.



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.

