Error:

The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine.

Error Message:

Causes:

• Turn on Data Execution Prevention [DEP] for Essential Windows Programs and Services.
• This usually happens when dll’s are not registered. Precisely, when the runtime is not even able to tell what the object is, and the object is not able to propagate more info back. It could be any component. It is a mismatched DLL file.
• Need to repair Microsoft data access components [MDAC].

Solution 1: Turn on DEP

• Right click My Computer > Click Advanced > Click Performance Settings.
• In Visual Effects tab Select “Let windows choose what’s best for my computer.
• In Data Execution Prevention tab select “Turn on DEP for essential Windows Programs and services only”.

Solution 2: 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.