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; } } }

ArcGIS Pro Ability to read Access Database

BrettHeist

ArcGIS Pro 2.2.0

Does this not support the ability to view Access Databases when adding data to a map like in ArcMap!? When I navigate to where my database is located through the "add data" window there isn't anything showing up. Now I have to go back to ArcMap so I can work with my data...frustrating

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

TedKowal

Brett, to be fair to ESRI, MS Access, does have a 64bit flavor, does not perform well when the data is closing in on the Gigabyte data range and starts performing worse and worse as the data size increase. However, in day to day practice, work from start to finish, speed is not measured by the efficiency of the data base alone, it includes preparation, communication with other software, conversions, cleaning, data accessibility, post operations and finally completion. The efficiency of your database is important but in a lot cases that is negligible. What access gives a user is ungodly compatibility with almost EVERYTHING so in most cases other than the data speed (which is only a small percentage of the work effort)...you will be spending enormous amount of time and extra work to get data into the system, overhead management of the large databases, or file geodatabase, now have to export that data out to format other applications can read, for example, for reporting I use crystal reports, I know that product cannot read a file geodatabase, so right there is an additional step I would have to make exporting the data into a format that can be read. While it is true, MSACCESS geodatabase is inefficient with large datasets, my point is that the Pre and Post time savings using Access far overwhelms it slowness in geo-processing.

Please do vote: Enable ArcGIS Pro to access ESRI Personal Geodatabases

ThomasColson

In response to the incredulous discovery that Pro can't even execute "Find and Replace", don't forgot to add your vote and use case to https://community.esri.com/ideas/13295

BrettHeist

I have really come to love Pro and it's project-centric approach though but I'm just left dumbfounded when I come across some functionality being left out like that. From what I read in one of Ted's threads and the discussion he was having about the access database reading ability being left out, it seems ESRI is taking the approach of telling us what we need and don't need and that seems like a dangerous precedent to set. When you participate in the ESRI feedback option when installing ArcMap or Pro, they should really keep a log of what features that user is using the most to be shared back so they can better understand their audience. Sure it's not that simple, but would be awesome if they could!

RobertBorchert

That is one of the number tops reasons we do not use Pro

BrettHeist

Yes, that feels like a huge oversight to not include that ability in Pro! I keep coming across issues like that the more I use Pro and am always shocked. I can't believe they also took the ability to search and replace in an attribute table away as well!! Are you kidding me, how was that something they looked at and thought it would be ok to remove? I wonder what the reasoning was there? Maybe lack of communication with the user community?

BrettHeist

Done!

TedKowal

But a shape file is?

MS Access if VERY compatible with Portal and Online Servers ... direct experience with this!

TedKowal

Vote here Enable ArcGIS Pro to access ESRI Personal Geodatabases and possibly some action will be taken. I know for fact...currently our department will not migrate to pro if MS Access is not accepted.

RobertBorchert

Isn't' going to happen. You need to load your date into a file geodatabase

Pro was built around being the most compatible with Portal/server/online. For which you need a file GDB or SDE

BrettHeist

noted

JoeBorgione

This has been discussed a number of times:

ARC GIS Pro Data Sharing

Enable ArcGIS Pro to access ESRI Personal Geodatabases

https://community.esri.com/message/733027-re-linking-an-arcgis-pro-gdb-to-ms-access?commentID=733027#comment-733027

etc... etc....

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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