Download Accessdatabaseengine.exe

2 views

Skip to first unread message

Merja Caryk

unread,

Aug 3, 2024, 5:53:20 PM8/3/24

to caytawordcoun

I have office 2010 32 bits version installed on my 64 bits home edition windows. I have installed accessdatabaseengine.exe as suggested by everyone. However, I am still not able to see microsoft ace oledb 12.0 to connect to my 2010 access database file (.accdb). I have clicked on force32 bit while connecting to eledb driver.

I know recently in Dec, 2020 I think, one could now connect to MS Access tables via Pro. I've been trying to get this to work and unable to see the ODBC connection to the Microsoft Office 12.0 Access Database.

First I've successfully made the connection to use Excel tables in Pro via ( -blog/products/arcgis-pro/data-management/guide-to-connecting-to-excel-fi...). This of course required me to use the 32-bit accessdatabaseengine.exe from Microsoft and doing the silent install on my C:drive which worked.

Is there something I'm missing here? We are using MS 365 for Enterprise and in Program and Files it does show that the 32-Bit accessdatabaseengine.exe is installed (as I can now use excel tables in Pro).

I looked at that, and it seems that method would work to import the tables from Access, however, our access tables are live and constantly update and so I'd like to find away for it to work as it does in ArcMap unfortunately...

1) I see you have the Microsoft Access Database Engine 2016 Redistributable installed on your system in addition to MS office? This needs to match the 32bit or 64bit installation of Office - please confirm. Once you click the download button you will have the option to select the version or just download both.

I did get this to work when I had the 64 Bit Version of Office 365 installed with the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable. On another system with the 32-bit versions installed it did not work. I will put a support case in with ESRI for a possible bug.

Yes this is what I have been doing. We're using the 32-Bit MS Office 365 here. I can't use the 64-bit because after installing it, Access fails to open, so I had to remove it each time I tested the 64-bit Microsoft engine. The 32-bit one allows Access to open, but I do not see as shown above, any of the Microsoft Database Engine options in the ODBC Database Connect.

It is my understanding that ArcGIS Pro requires the 64-bit Microsoft Access Database Engine 2016 Redistributable be installed as it is a 64-bit application even when running a 32-bit version of office. I now have both the 32-bit and 64-bit version of the Microsoft Access Database Engine 2016 Redistributable installed and no issues yet.

See that's what I've been doing and I'm unable to see that. I've been doing both on the C drive via quiet mode. I haven't tried it in /passive at all, but heard that wasn't the best way. The biggest issue as I mentioned, is when doing the x64 it then prevents Access itself from opening up and causes an error. This is where I'm at a loss. So it seems maybe something else is going on in the background then if you can get it to work and I am not able to see that.

I just tried it again and for some reason I was able to see the MS Office 12.0 and 16.0 now. However, the issue is the same that when installing the 64-bit, I can no longer open access. Using the 32-bit one I am, but then I can't see the MS Office 12 or 16 in Pro:

Since you are using Office 365 you should be able to download and install the 64-bit version of office this may eliminate the compatibility issue. I do not have access to a 64-bit version until this evening to confirm if you can still open Access with the 64-bit version of Microsoft Access Database Engine 2016 Redistributable installed but will check it out tonight. I know the drivers were showing but I did not try to open Access.

Since version 3.20, QGIS has used the .msi installer only and users should choose the QSWAT3_9 download above. However, if you have an older version of QGIS and installed with the .exe installer, please install QSWAT3_64. This version requires Microsoft Office 64 bit or the 64 bit Microsoft Access Database Engine Redistributable 2016.

If you have a 32 bit machine or you have a 32 bit version of Microsoft Office on a 64 bit machine, you need a 32 bit version of QGIS (you should choose 3.16 and the 32 bit .exe stand alone installer, not the MSI version) and QSWAT3. You should also download and install Microsoft Access Database Engine Redistributable 2016, and choose the 32 bit version (called accessdatabaseengine.exe).

If you make a mistake and there is a mismatch between your version of Microsoft Office and the database engine you choose, you will get a warning that you need to uninstall Microsoft Office. Don't do that! Back out without uninstalling Office and check these release notes again.

QGIS2 is no longer supported and we recommend using QSWAT3 for QGIS3 linked above. You may still download QSWAT v1.9 here. It is necessary to use QGIS 2.6, 32-bit version. Please read the user manual for installation instructions.