Microsoft.jet.oledb.4.0' provider is not registered on the local machine

try to register oledb 4.0 on your local machine using command prompt

below are thge step to register jet4.0
if your system is 32 bit
1. Open cmd as administrator
2. type cd c:\windows\System32 press enter
3. type regsvr32 msjet40.dll press enter
4. type regsvr32 msjetoledb40.dll press enter
5. type regsvr32 msjint40.dll press enter
6. type regsvr32 msjter40.dll press enter
7. type regsvr32 msjtes40.dll press enter

note: some dll will not register.

if your system is 64 bit
1. Open cmd as administrator
2. type cd c:\windows\Syswow64 press enter
3. type regsvr32 msjet40.dll press enter
4. type regsvr32 msjetoledb40.dll press enter
5. type regsvr32 msjint40.dll press enter
6. type regsvr32 msjter40.dll press enter
7. type regsvr32 msjtes40.dll press enter

note: some dll will not register.

After registering these dll's test your application
if it again showing popup that "Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine"

Install Office database engine 2007 from the below link
microsoft office access database engine 2007

Hope after doing these your problem should be solved

1. From the solution explorer right-click your project then click Properties
2. Click the Build tab
3. Change Platform target from: Any CPU to x86
4. Re-build your solution

I was not selecting Active (Release). Once this was selected the .exe from the release folder worked.