Q: microsoft.ace.oledb.12.0 provider is not registered error fixing from code behind My application is working fine in 32 bit machine but when i rum my application from 64bit machine it is showing error like "microsoft.ace.oledb.12.0  provider is not registered". i searched for the solution and every one suggesting about installing 64 bit compatible OLEDB driver .I would like to know whether it is  fixed from code behind.Any valuuble suggestion are appreciated.
Thanks in advance
Subin

A: My answer might look strange but have you seen this solution  'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine solution?
I mean especially first approach.

A: You can change the target CPU to work on 64bit  and 32bit


*

*Go to the startup project of your program.

*Open the properties window.

*Click the compile tab.

*Click advanced compile options.

*Change the target CPU options to any CPU.

