I am working to link spatial data in ArcGIS 10.3.1 (parcels with many attributes) to an Access database of customers.
Initially all I need is to identify which parcels are in my database and append the landowner names to the attribute table.
I think I can accomplish this a single time with a join.
However, I am constantly adding new customers to Access.
My desired end result is to be able to sort the parcels that are customers at any given time without having to re-join the tables.
So my larger question is:
Can (and should) I keep that link live so that it updates my parcel attributes when I have a new customer?
I would only be editing one way – data entered in Access and sent to Arc. I have no need to use the spatial data in Access.
Is there a good solution for this?
Best Answer
Personally, I'm not sure without any script you can update features attributes automatically, but if you want create a connection between ArcGIS and Access you should read this instruction
"Connecting to a Microsoft Access database in ArcGIS"
and
"Understanding how to use Microsoft Access files in ArcGIS"
and get help from
"Link Excel Table to Access/Arcmap Personal Geodatabase Table"
moreover
"Arcgis table and Excel sheet dynamic linking"
I believe these references would be helpful. I hope so. Excel and Accese are approximately same.