I created a windows application developed in .NET 3.5 using MS Access local database. and I found a solution for this problem. The issue I described in my question occurred basically due to the incompatibility of the Microsoft.Jet.OLEDB.4.0 driver in 64 bit OS.
So if we are using Microsoft.Jet.OLEDB.4.0 driver in a 64 bit server, we have to force our application to build in in 32 bit mode
This is how to fix this problem. Please follow this step by step.
- Right Click the project name and Click Properties.
2. Click Build option.
3. Change change Platform target to “x86”.
- x86 means your application run as 32bit in your machine.