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?