How do I maintain Qualified Field names when linking to ACCESS

07-05-2019 02:24 PM
New Contributor

I'm using Arc 10.5 on our corporate server and trying to link to an ACCESS query. I've set up both a Microsoft OLE DB Provider for ODBC Drivers and Microsoft Office 12.0 Access Database Engine OLE DB Provider odc link. They both work and I link fine to my Access queries, except for any queries that have duplicate field names. In Access, the fields are fully qualified with the table names, but the table names do not exist on the Arc side when I link, which causes the duplicate field names. I cannot figure out how to maintain the table prefix on the field name so as to not have duplicate field names.

Any suggestions?

Thank you.

0 Kudos
0 Replies