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

[threeo]

I have a pretty simple app that inserts into an access database. When I first wrote it, I kept getting this error:

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

I don't remember what I did to get rid of that error but I got rid of it. I am now starting a new app and I cut and pasted the code from the working app and the new app gives me that same error.

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

anyone know why app 1 doesn't give me the error while app 2 (with EXACTLY the same code - copied and pasted) gives me that error???

 

[kulrom]

There is not 64-bit Jet OLEDB Provider so you have to change the Target CPU.


To set the Target CPU property

1. With a project selected in Solution Explorer, on the Project menu, click Properties.

2. Click the Compile tab.

3. Click the Advanced Compile Options button to open the Advanced Compiler Settings dialog box.

4. Choose a CPU type from the Target CPU drop-down list. The options are AnyCPU (the default), x86, x64, or Itanium.

5. Select x86 and Click OK.



Shorten:
Properties -> Compile -> Advanced Compile Settings -> Target CPU -> x86