topic Re: MS Access database joined to a Feature Class in Data Management Questions

MS Access database joined to a Feature Class

JohnMellor__GISP — Fri, 12 May 2017 18:13:00 GMT

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.

Re: MS Access database joined to a Feature Class

JayantaPoddar — Fri, 12 May 2017 19:00:07 GMT

Have you verified if TrafficSignals.mdb is a personal geodatabase. A PGDB also has *.mdb format, and you could view its content from ArcGIS Desktop (Catalog/Map).

Re: MS Access database joined to a Feature Class

JohnMellor__GISP — Sat, 13 May 2017 22:29:36 GMT

TrafficSignal.mdb is not a personal geodatabase. It is just an MS Access database. I can't open it in ArcMap or ArcCatalog. I receive an error that I need a password, but there is no password. It's behaves like there was a linked access list at one time.

Re: MS Access database joined to a Feature Class

shan_sarkar — Mon, 15 May 2017 06:14:32 GMT

What is the version of ArcGIS desktop and MS Office?

As you have mentioned that your data TrafficSignal is an Access database, can you try to export it as an excel as a temporary solution. That way you can at least join the data and then try to troubleshoot the issue.

However, you need to ensure that you have installled Download 2007 Office System Driver: Data Connectivity Components from Official Microsoft Download Center

~Shan