Error Message
Please verify that the Microsoft Data Access Components 2.1(or Later) have been properly installed.
Explanation of Error
Control, SMS, or the SSLIP are encountering problems accessing the Microsoft Access databases that are used with the program. These databases are accessed using the Microsoft Data Access Components (MDAC). Microsoft Data Access Components (MDAC) are distributed with various products. Since Windows 2000, they have been a core part of the operating system, and come under Windows File Protection.
Severity
High - If you receive this error you will be unable to utilize the program until it is resolved.
Possible Root Cause(s)
- Corruption installation of MDAC
- Missing registry entries for MDAC, viruses, malware, etc. and the removal tools are notorious for breaking system components.
Resolution #1
- Download the redistributable package MDAC_TYP.exe
- Extract the package to a folder, using the command:
- mdac_typ /C /T:c:\temp\mdacinst
- Locate the file MDACXPAC.INF. Right-click and choose “Install”.
- Restart your computer.
Resolution #2
- Expand the file MDACXPAK.CAB in the C:\Temp\Mdacinst\ folder using a Winzip, Winrar, etc.
- Create and run the MAKEDIRS.BAT file to create the directories:
md ADO copy /b MSADER15.DLL ADO\*.* copy /b MSADO15.DLL ADO\*.* copy /b MSADO20.TLB ADO\*.* copy /b MSADO21.TLB ADO\*.* copy /b MSADOMD.DLL ADO\*.* copy /b MSADOR15.DLL ADO\*.* copy /b MSADOX.DLL ADO\*.* copy /b MSADRH15.DLL ADO\*.* copy /b MSJRO.DLL ADO\*.* md MSADC copy /b MSADCE.DLL MSADC\*.* copy /b MSADCER.DLL MSADC\*.* copy /b MSADCF.DLL MSADC\*.* copy /b MSADCFR.DLL MSADC\*.* copy /b MSADCO.DLL MSADC\*.* copy /b MSADCOR.DLL MSADC\*.* copy /b MSADCS.DLL MSADC\*.* copy /b MSADDS.DLL MSADC\*.* copy /b MSADDSR.DLL MSADC\*.* copy /b MSDAPRSR.DLL MSADC\*.* copy /b MSDAPRST.DLL MSADC\*.* copy /b MSDAREM.DLL MSADC\*.* copy /b MSDAREMR.DLL MSADC\*.* copy /b MSDFMAP.DLL MSADC\*.* md "OLE DB" copy /b MSDADC.DLL "OLE DB\*.*" copy /b MSDAENUM.DLL "OLE DB\*.*" copy /b MSDAER.DLL "OLE DB\*.*" copy /b MSDAORA.DLL "OLE DB\*.*" copy /b MSDAOSP.DLL "OLE DB\*.*" copy /b MSDAPS.DLL "OLE DB\*.*" copy /b MSDASC.DLL "OLE DB\*.*" copy /b MSDASQL.DLL "OLE DB\*.*" copy /b MSDASQLR.DLL "OLE DB\*.*" copy /b MSDATL2.DLL "OLE DB\*.*" copy /b MSDATT.DLL "OLE DB\*.*" copy /b MSDAURL.DLL "OLE DB\*.*" copy /b MSXACTPS.DLL "OLE DB\*.*" copy /b OLEDB32.DLL "OLE DB\*.*" copy /b OLEDB32R.DLL "OLE DB\*.*" copy /b OLEDB32X.DLL "OLE DB\*.*"
- Copy the three subfolders to C:\Program Files\Common Files\System\, overwriting the existing files and folders.
- Create and the REGFILES.BAT file in the C:\Program Files\Common Files\System\ folder:
regsvr32 /u /s ADO\msado15.dll regsvr32 /u /s ADO\msador15.dll regsvr32 /u /s ADO\msadrh15.dll regsvr32 /u /s ADO\msadomd.dll regsvr32 /u /s ADO\msadox.dll regsvr32 /u /s ADO\msjro.dll regsvr32 /u /s MSADC\msadce.dll regsvr32 /u /s MSADC\msadcf.dll regsvr32 /u /s MSADC\msadco.dll regsvr32 /u /s MSADC\msadds.dll regsvr32 /u /s MSADC\msdaprst.dll regsvr32 /u /s MSADC\msdarem.dll regsvr32 /u /s MSADC\msdfmap.dll regsvr32 /u /s "OLE DB\oledb32.dll" regsvr32 /u /s "OLE DB\msxactps.dll" regsvr32 /u /s "OLE DB\msdaenum.dll" regsvr32 /u /s "OLE DB\msdaurl.dll" regsvr32 /u /s "OLE DB\msdatt.dll" regsvr32 /u /s "OLE DB\msdasql.dll" regsvr32 /u /s "OLE DB\msdaosp.dll" regsvr32 /u /s "OLE DB\msdaora.dll" regsvr32 /u /s "OLE DB\msdaps.dll" regsvr32 /s ADO\msado15.dll regsvr32 /s ADO\msador15.dll regsvr32 /s ADO\msadrh15.dll regsvr32 /s ADO\msadomd.dll regsvr32 /s ADO\msadox.dll regsvr32 /s ADO\msjro.dll regsvr32 /s MSADC\msadce.dll regsvr32 /s MSADC\msadcf.dll regsvr32 /s MSADC\msadco.dll regsvr32 /s MSADC\msadds.dll regsvr32 /s MSADC\msdaprst.dll regsvr32 /s MSADC\msdarem.dll regsvr32 /s MSADC\msdfmap.dll regsvr32 /s "OLE DB\oledb32.dll" regsvr32 /s "OLE DB\msxactps.dll" regsvr32 /s "OLE DB\msdaenum.dll" regsvr32 /s "OLE DB\msdaurl.dll" regsvr32 /s "OLE DB\msdatt.dll" regsvr32 /s "OLE DB\msdasql.dll" regsvr32 /s "OLE DB\msdaosp.dll" regsvr32 /s "OLE DB\msdaora.dll" regsvr32 /s "OLE DB\msdaps.dll"
Resolution #3
- You can attempt a Windows Repair.
- You can run sfc /scannow in an elevated command prompt.
- You may ultimately have to format and reinstall Windows.
Version Information
This content of this article was pulled from various sources, but mostly from Glocksoft's support page .
You could leave a comment if you were logged in.