Select to view content in your preferred language

Personal GDB(.mdb) import tool

13375
32
04-20-2018 09:32 AM
Status: Implemented
Labels (1)
RobertGraham
Occasional Contributor

Since ArcGIS PRO currently does not have a native method for reading data from Microsoft access databases(.mdb) we need a tool at least to import the data into a file geodatabase.  It would be best to natively read the personal geodatabases instead of importing.  

Many companies still use the personal geodatabase because of the ease of development in MS access for forms and reports.  

Please vote up this idea.Microsoft Access (.accdb) Support in ArcGIS Propug list #pug puc

32 Comments
AlfredBaldenweck

Not sure about what the 8.x ones looked like (never found one to crack open and test, please send me one if you have one) but 9.x had a different schema. Still usable and retrievable with knowhow, but it was set up differently.

For example, 10.x used the GDB_Items table to list everything, and the Definition Field used XML(?) to determine what type of object it was. (You could also look at DatasetSubtype1 and DatasetSubtype2, but I've never had to for what I was looking for.) The GDB_Items table include Mosaics, feature classes, raster catalogs, feature datasets, domains, etc. You could look at the Path field to tell if something was in a feature dataset.

AlfredBaldenweck_0-1781098627385.png

In contrast, the 9.x used the GDB_ObjectClasses table to list everything, but it gave really no details otherwise. It mentions if a feature class is in a feature dataset, for example, but doesn't actually tell you which one that is.

AlfredBaldenweck_1-1781098725085.png

Instead, you have to go to each table for each object type and investigate.

AlfredBaldenweck_2-1781098826042.png

Once there, you still don't have any details on the feature class, although you'll notice that FeatureType and GeometryType match with the DataSubtype1 and DataSubtype2 fields in 10.x

AlfredBaldenweck_3-1781098944566.png

To be honest, I can't remember how to find the spatial reference in 9.X for each table. You can find it pretty easily for Feature Datasets (SRID field has the objectid for the matching spatial reference in the spatial reference table) but Idk about the tables themselves.

Anyway, the information can be retrieved but it's a lot more hoops to jump through.

There's also the Access97 problem, which is any database saved in Access97 is unopenable by anything other than ArcMap and Access <=2006 because of the drivers used. It's very possible that Esri saw that problem and rolled the dice that anything <=9.x would be unopenable, anyway, so it doesn't make sense to devote dev time to solving for it, which is sad but understandable. I would like a later release to include 9.x, at least, though. I'm very happy that this tool finally came out, but everything can be improved one way or another.

(I'm also curious as to what this tool does with raster catalogs)

 

 

SSWoodward

Thanks everyone for your comments.  The tool supports 10.x geodatabases. 9.x and 8.x  are not supported.

More info about what is and is not supported can be found in the documentation here.