Error:

The .net framework data providers require microsoft data access components (MDAC).Please install microsoft data access components (MDAC) version 2.6 or later.

Error Message:

Causes:

• This error indicates that you have a corrupt installation of “MDAC 2.8” (Microsoft Data Access Components) on your computer.
• The most common cause for this error is mismatched DLL files with Microsoft Data Access Components (MDAC).

Workaround 1 [For Windows Xp] : Re-Install the MDAC

1. Navigate to C:\Windows\Inf  folder.
2. Search for mdac.inf file.
3. Right click mdac.inf and Click Install.
4. When installation wizard prompts for each of the following files, try to browse and locate them in the directories specified.
   • adcjavas.inc – C:\Windows\servicepackfiles\i386
   • handler.reg – C:\Program Files\Common Files\System\msadc
   • MDACRdMe.htm – C:\Program Files\Common Files\System\Ado
   • oledbjvs.inc – C:\Program Files\Common Files\System\Ole DB
   • mssoap1.dll – C:\Program Files\Common Files\MSSoap\Binaries
   • mssoapr.dll – C:\Program Files\Common Files\MSSoap\Binaries

Note:

• If the required files are not there, you are required to copy OLE DB, msadc, Ole DB and Binaries folders from another computer and place them in the C:\Program Files\Common Files\System32 folder.
• Otherwise insert Operating system CD later click on OK, later installation succeeds.

Workaround 2 : [For Windows 7 & above]

Perform sfc /scannow

open command prompt as run as admin, type command  sfc /scannow , it may take some time to complete the process, see for the result, restart the system once  and see whether issue is solved.