topic Re: Connecting access database from ArcMap to ArcPro? in ArcGIS Pro Questions

Connecting access database from ArcMap to ArcPro?

bikeMapper312 — Mon, 09 Aug 2021 15:14:34 GMT

I currently have a layer in ArcMap that has an inventory of sidewalks in an area. The layer is connected to an Access Database. When we update the Access Database, the layer in ArcMap updates as well. I have to continuously make edits to this layer and it would be much better to do in pro.

I want to move the layer into ArcPro for future updates, but I am not sure how to. I can easily export the layer and add it to a new ArcPro project, but it isn't connected to the exisiting Access Database. Any tips?

Re: Connecting access database from ArcMap to ArcPro?

KoryKramer — Mon, 09 Aug 2021 15:28:49 GMT

I can't be entirely sure but you might try creating the connection from ArcGIS Pro. See https://pro.arcgis.com/en/pro-app/latest/help/data/databases/work-with-ole-db-connections.htm

Then if you have symbology from ArcMap to maintain in Pro, https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/apply-symbology-from-layer.htm takes .lyr as input.

Would that work for you?

Re: Connecting access database from ArcMap to ArcPro?

Anonymous User — Mon, 09 Aug 2021 19:18:39 GMT

Using ArgGIS Pro 2.7.0 I was able to add my MS Access Database using an OLE database connection in Catalog. I was not able to do this with previous versions (not sure which version added the functionality and we skipped versions).

Re: Connecting access database from ArcMap to ArcPro?

KoryKramer — Mon, 09 Aug 2021 19:24:00 GMT

You're correct. I'm pretty sure the OLE DB functionality was added in ArcGIS Pro 2.6: https://pro.arcgis.com/en/pro-app/2.6/help/data/databases/work-with-ole-db-connections.htm

Re: Connecting access database from ArcMap to ArcPro?

bikeMapper312 — Mon, 27 Sep 2021 15:58:01 GMT

Thank you!

So I think I got the OLE db connection working. Now the access database is connected to arcpro.

Ideally, I would like to share the ArcGis pro project as a web map to be shared publicly. Likewise, I would like to use the access database to consistently update this online web map. If the access database is connected to the arcgis pro project, will the access database update the shared web map as well?

Re: Connecting access database from ArcMap to ArcPro?

Anonymous User — Mon, 18 Oct 2021 20:48:28 GMT

I believe that the only way to have dynamically updated data is to provide a rest service.

Otherwise you need to republish the project to refresh the data.

Re: Connecting access database from ArcMap to ArcPro?

SloanCampi — Tue, 23 Nov 2021 17:29:50 GMT

I have a layer in ArcGIS Pro that has an inventory of all bus stops in our transit system, which is connected to an Access Database. We regularly have to update the Access Database based on Service Changes, etc. A couple questions

1. How do you get the layer to update when you update the Access Database? Is this done automatically?

2. We have hyperlinks in the MS Access Database to photos, but when I added these to ArcMap, the attribute table doesn't read the hyperlink correctly, and the fields just populate with "Blob."