#Add ole db connection arcgis 10.3 install#
#Add ole db connection arcgis 10.3 Patch#

I now have both the 32-bit and 64-bit version of the Microsoft Access Database Engine 2016 Redistributable installed and no issues yet. Under Enter the object name to select add the name of the computer your using to access the file. Add a favorite database to projects without having to remember its location or any connection details. on 'Advance Security Settings' click Share tab. The project favorites collection is always available. If you add the same database to many projects, favorite that database to simplify the process. 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. The database connection is updated with the new name.

#Add ole db connection arcgis 10.3 install#

This will install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable even though you have the 32-version of Office.ĥ) You should now see the MS Office 12.0 and 16.0 Access Database Engine OLE providers listed. You may need IT to install this for you, if you are in an enterprise environment.Ĥ) Type 'AccessDatabaseEngine_X64.exe /quiet'. This will be the AccessDatabaseEngine_X64.exe file.Ģ) Since you have the 32-bit version of Office installed you will need to install the file using the quiet mode otherwise the 64-bit version will not install and fails with a warning.ģ) Open an administrative CMD window in the folder that has the file you downloaded.

However, this is against Microsoft’s recommendation not to install the 64-bit version of Microsoft Access Database Engine 2016 Redistributable with any 32-bit Office products installed.ġ) From Microsoft, download the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable. 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). However in Pro, I still do not see any reference to any Microsoft Office 12.0 Access Database which from ( )I should be seeing. An Oracle 11g R2 or Oracle 12c database client must be used to connect to an Oracle 10g R2 database.

#Add ole db connection arcgis 10.3 Patch#

Looking at my ODBC Data Connections on my system, I see that in both the 32-Bit and 64-Bit have the MS Access Database listed for *.mdb and *.accdb. Oracle 10.2.0.3 STGEOMETRY users need to apply Oracle Patch that fixes Oracle bug 6756089. 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.

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