14/01/2015 by Nitesh

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

Friends,

While working with Access, many times you may get the famous exception “Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine“. This normally happens that your code runs fine on your development machine and when you try the run it on production server, this error comes. IN this post, we will see a solution to the same.

This happens because there is no 64 bit version of Jet. To resolve this, you need to do the following steps –

Select the Project in Solution Explorer and right-click on it to open its Properties
Select Build Tab from the Properties window, choose x86 as “Platform Target” on the screen
Save the project & recompile.