Procedure to fix problems with Data-Access (MDAC)


The information in this article applies to:

  •  EcoNorm
  •  EcoNorm Manager
  •  EcoPrint

Document-ID 010808.03 ENG

Problem: On Application-Startup or during certain tasks the application reports "Can't create Object", "Can't access Database", "MDAC not properly installed" or similar Messages

Cause:
Most likely the "Microsoft Data Access Components" ("MDAC") are not properly installed Certain applications running under Win 9x and NT require MDAC to be installed. Windows 2000 already comes with MDAC 2.6, however we have seen that it can become damaged. Microsoft Office, SolidWorks and many other applications which need to access a Windows-Database will install a more or less current and complete set of the MDAC files (or break a previous installation...).

Resolution:
First, check whether on your system is a complete and current installation of MDAC with the Microsoft-Tool "Components Checker". No registry keys or files must be missing, furthermore no version conflicts must be listed. Because Components Checker is not localized, warnings regarding unexpected file locations may eventually be ignored. The installed version should be at least 2.5SP1.

Windows 9x, Win NT: When component checker reports problems you need to reinstall the MDAC-files. When you received a CD-ROM from us, we usually provide the current MDAC files in the folder "MDAC". If you only have a downloaded version, or want to make sure you have the most current version, you need to browse to www.microsoft.com and search for "MDAC". Select your language and operating system and download the file (typ. 8-10 MB).
Then log on with Administrator rights and start MDAC.EXE you just downloaded or from our CD-ROM. Typically you need to reboot the system. When you log on please use the Administrator account once more for the installation to complete.

Win 2000: Because MDAC is integrated with Windows 2000, it is normally under the system file protection. Hence Windows 2000 does not allow to reinstall MDAC. You can check the status of the system files with the tool "sfc.exe" (located in the system32 folder, see Windows 2000 help). Eventually you may need to copy files from the original CD and/or apply any service packs. Afterwards check the MDAC status with "Components Checker".

Created: Aug. 08, 2001