Community

Make tabular edits to MS Access table in ArcGIS Pro

428
2
12-02-2022 06:59 PM
Labels (1)
Labels
Bud
by
Notable Contributor
‎12-02-2022 06:59 PM

Is there a way to make non-spatial edits to a Microsoft Access table in ArcGIS Pro? (.mdb or .accdb)

For example, an Access table has XY columns. I'm displaying the table as an XY event layer in ArcGIS Pro. As I review the XY points in the map, I want to edit a flag column with Y/N values.

Is there a way to do that?

I'm not the owner of the Access database so I don't have the option of migrating it to a different format.

0 Kudos
2 Replies
Bud
by
Notable Contributor
‎12-02-2022 07:00 PM

I'm aware that I could use a copy of the table as a workaround:

  • Copy the table to a ArcGIS editing-friendly format.
  • Display and edit the copy in ArcGIS Pro.
  • When done editing:
    In Access, join the copy to the master table.
  • Update the Access master table using the copy.

But that's messy and not ideal. It would be better if I could edit the master Access table right in ArcGIS Pro.


Related: Stack Overflow - Edit local MS Access table via HTTP-like request?

0 Kudos