Select to view content in your preferred language

Install ODBC/SQLite driver by default in Pro to allow viewing/editing complex Mobile GDB relational data in MS Access

519
0
06-22-2022 06:27 PM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

@StevenDel_Favero said this in Migrating from Personal GDB to Mobile GDB:

The main advantage of the Personal GDB was the ability to query and edit the data in Microsoft Access. This is not an inherent ability for Mobile Geodatabases and ArcGIS is not at all adequate for working with complex relational data. The ability to open a SQLite database in MS Access requires a third party ODBC driver. As a government employee, I do not have the luxury of installing such a driver on my machine, let alone having this driver installed on the Remote Desktop server where my agency does all of its work. Getting approval to have something like this installed may never be possible or will take a very long time (I am starting to petition for it). Is it possible to have this ODBC Driver installed along with ArcGIS Pro in future releases? Otherwise a Mobile Geodatabase does not have much value and is not a valid alternative to a Personal GDB. Not being able to use a Personal GDB in ArcGIS Pro is therefore a serious impediment to my workflow and Esri has still not provided an alternative for me.

Could Esri consider installing an ODBC/SQLite driver by default along with Pro to allow viewing/editing complex Mobile GDB relational data in MS Access? That would let us move forward with switching from PGDBs to mobile geodatabases.