Solution: ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine
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.
Hope this helps you! Keep learning & sharing! Cheers