topic Re: ArcGIS Pro Ability to read Access Database in ArcGIS Pro Questions

ArcGIS Pro Ability to read Access Database

BrettHeist — Thu, 12 Jul 2018 13:24:55 GMT

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

Re: ArcGIS Pro Ability to read Access Database

JoeBorgione — Thu, 12 Jul 2018 13:59:55 GMT

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

Re: ArcGIS Pro Ability to read Access Database

BrettHeist — Thu, 12 Jul 2018 14:08:28 GMT

noted

Re: ArcGIS Pro Ability to read Access Database

RobertBorchert — Thu, 12 Jul 2018 14:25:06 GMT

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

Re: ArcGIS Pro Ability to read Access Database

TedKowal — Thu, 12 Jul 2018 14:36:27 GMT

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.

Re: ArcGIS Pro Ability to read Access Database

TedKowal — Thu, 12 Jul 2018 14:37:37 GMT

But a shape file is?

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

Re: ArcGIS Pro Ability to read Access Database

BrettHeist — Thu, 12 Jul 2018 14:38:39 GMT

Done!

Re: ArcGIS Pro Ability to read Access Database

BrettHeist — Thu, 12 Jul 2018 14:41:46 GMT

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?

Re: ArcGIS Pro Ability to read Access Database

RobertBorchert — Thu, 12 Jul 2018 14:55:00 GMT

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

Re: ArcGIS Pro Ability to read Access Database

BrettHeist — Thu, 12 Jul 2018 15:05:12 GMT

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!

Re: ArcGIS Pro Ability to read Access Database

ThomasColson — Tue, 22 Jun 2021 08:44:40 GMT

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

Re: ArcGIS Pro Ability to read Access Database

TedKowal — Fri, 13 Jul 2018 15:48:36 GMT

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