connect to a geodatabase in MS Access

Question

I want to be able to edit and update my data using ms access, and then somehow click a button or two and update a geodatabase for making maps and querying in ArcGIS, which is problematic as we sit now, due to the lack of an Oject-ID field in my access database.  If I can figure out how to link to a geodatabase table in access, I can update the geodatabase with a simple query.

bharold · Answer

For a no-code option Data Interoperability will do the job as a geoprocessing tool.

JoeBorgione · Answer

Take a look at this blog post from Bruce Harold‌: https://community.esri.com/community/arcgis-data-interoperability/blog/2019/09/26/using-odbc-data-sources-in-core-arcgis-pro

BTW, the personal geodatabse that was once available has gone the way of the dodo, for better or for worse.