I am trying to build a Visual Basic. Net 2008 application that connects to an Access database filr(.mdb). Initially I got an error that Microsoft.Jet.Oledb.4.0 is not registered on the local machine. After googling for sometime I found out that the Microsoft.Jet doesn't work with a 64-bit operating system and I download the Microsoft.Ace.Oledb.12.0 64-bit, upon installing it conflicted with my 32-bit office installation. I downloaded the 32-bit version and installed which installed correctly and afterwards changed the connection string to Microsoft.Ace.oledb.12.0. Well the test connection and everything worked except I couldn't see my data displayed when I debugged my application.
I bought 64-bit Office 2010 professional package and installed the 64-bit of the Ace.Oledb but when i try to create a query I still get the error Microsoft.Ace.Oledb 12 is not registered on the local machine. It works on Office 2007 though.Please I need help urgently.