I have a Feature Class - Traffic Signals - that has a unique identifier - Location. The Location field contains a number that cross references to an MS Access database - TrafficSignals.mdb - table that has a Location field. The MS Access database has multiple other tables that can relate through the Location table.
We are looking for suggestions of how to manage this data, through Best Practices.
Our goal is to move out of the MS Access database and import the data into our GIS and CMMS, based on the data in each table.
But I'm wondering if there is a temporary solution. I did attempt to add the database into an ArcMap through an ODBC but received the error that there was a password / security issue. Which there is no password to the database.
Thanks for your input in advance.