We have an application that makes use of OLEDB and the Jet engine Microsoft.Jet.OLEDB.4.0. Canon golden eagle rewards program. We are converting our application to also run in 64-bit mode. However, the database engine is no longer a standard part of 64-bit Windows. But Office 2010 64-bit does install a 64-bit access database engine (See so you can use Microsoft.ACE.OLEDB.12.0. So I am working on fixing issues so that our application runs in 64-bit mode as well. But the OLEDB code complains about the database engine not being registered.

So I try to install the redistributable 64-bit engine on the above link. But it tells me I need to uninstall 32-bit Office 2007 first. No way am I going to do that, because I am sure some settings etc. Will be lost. So my questions are: How is that the 32-bit database access components do not work in 64-bit mode, but you cant install the 64-bit one if the 32-bit is installed already?

Microsoft Store; Free downloads. But Office 2010 64-bit does install a 64-bit access database engine. But it tells me I need to uninstall 32-bit Office 2007.

Does that make any sense to anyone at all?! I realize Microsoft wants people to switch to SQL server Express, except it is too invasive, does install reliably even on clean new Windows 7 computers, and it is not simple to copy or move the data around between different machines. Is there a suitable alternative to Jet then?

Free Download Bovine Radiology Book PDF Keywords Free DownloadBovine Radiology Book PDF, read, reading book, free, download, book, ebook, books, ebooks, manual. Bovine radiology pdf books.

Something that is simple but works on 32 and 64 bit and ideally has OLEDB support? SQLite looks promising but the database we create and use also has to accessible via VBA, VBScript and.NET etc. Hi Ben, The reason you have to uninstall the 32 bit engine and / or 32 bit Office is because you can’t have 32 bit Office products and components installed with 64 bit Office products and components. As mentioned, Jet is being deprecated but it is still included with Windows, it is just found in the SysWow64 folder on 64 bit machines and is still only a 32 bit component. A big misunderstanding that people have is Ace is not a replacement for Jet and is not intended to be used in the same way as Jet. It just so happens that there is a 64 bit Ace driver and people are using this driver as a replacement for Jet in order to create 64 bit applications and are running into issues when doing so.

That is why I said you first will need to ensure you are using Ace in a supported way. If you’re not, then you will either need to continue to use Jet or one of the other workarounds I mentioned in my last post.

Best Regards, Nathan Ost Microsoft Online Community Support. Hi Ben, If your application is compiled as a 64 bit application, it will not have visibility into the 32 bit drivers (including Jet 32 bit and Ace 32 bit) on the machine. In order to use these components, you would need to compile your application as an x86 app.

If you are planning on using the 64 bit version of Ace, then you first will need to ensure you are using it in a supported scenario since Ace is not a general replacement for Jet. The link you posted lists the supported scenarios for Ace (If you are able to use Ace in your scenario, then you will also need to ensure you have either 32 bit Office or 64 bit Office installed. Unfortunately, you can’t install the 64 bit version of Office or Ace (which is an Office component) onto a machine that has a 32 bit version of Office installed. It has to be one or the other. 2269468 You receive the error 'You cannot install the 64-bit version of Office 2010 because you have 32-bit Office products installed.' If Ace is not supported in your scenario, then depending on the types of files you are connecting to, you may be able to use Open XML to read and write data from the new Excel file format (xlsx) or SQL Server Express. Best Regards, Nathan Ost Microsoft Online Community Support.