nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Connecting access database from ArcMap to ArcPro?

bikeMapper312

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?

Find more posts tagged with

Accepted answers

KoryKramer

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

All comments

SloanCampi

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."

Anonymous User

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.

bikeMapper312

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?

KoryKramer

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

Anonymous User

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).

KoryKramer

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

All Communities
Recent Posts
Followed Content
Community Help

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.