Select to view content in your preferred language

I need to open a MDB file in ArcGIS Pro

36197
22
03-15-2018 08:52 AM
WilliamVong
New Contributor

Hello everybody! I need to open a MDB file in ArcGIS Pro, but seems that the extension is no longer support in the Pro version, do you have any idea of how i can work with the MDB file? In some post i found that I need to use ArcCatalog and now I´m using the ArcGIS Pro trial version and there is no ArcCatalog in the Pro version.

22 Replies
RobertBorchert
Honored Contributor

Describe how you created the new database. Did you do it from the stand alone ArcCatalog or did you create it using Catalog in Pro?

When you say you copied it, did you copy and paste.  or did you use stand alone arc catalog to Import the data.

It really should have worked the way you tried. it.   can you include a snip of what the data looks like in Arc Catalog

0 Kudos
jungao
by
Occasional Contributor

futura?

0 Kudos
Alex_at_Exprodat
Occasional Contributor

I've also posted this response on Personal GDB(.mdb) import tool - Page 2 - Esri Community but I thought you might like to reference here as well. These steps are also found at Problem: Unable to Add Data from Personal Geodatabases in ArcGIS Pro.

You can access MDB files directly in ArcGIS Pro. These steps worked for me:

  1. Create a new OLE DB connection in ArcGIS Pro: Work with OLE DB connections—ArcGIS Pro | Documentation
  2. For the provider, I selected "Microsoft Office 12.0 Access Database Engine OLE DB Provider"
  3. In the Connection tab, enter the full file path to the .mdb file, for example: C:\Users\arexroad\ArcGIS\PersonalGeodatabase.mdb
  4. For the user name and password, I left both empty. This only applies if the database requires user credentials.
  5. In the Advanced tab, I also set access permissions to "Read" only.

Test the connection to make sure it succeeds. Once added, I can view all of the database tables in the .mdb directly in the Catalog pane/view under Databases. The tables can be added to my maps and used in joins/relates/geoprocessing.

According to FAQ: Is It Possible to Connect to a Microsoft Access (.Accdb) Database in ArcGIS Pro? these steps should also work for .accdb database files.

0 Kudos