topic Re: Load .accdb query with field name Domain in ArcGIS Pro Questions

Load .accdb query with field name Domain

sbrof — Wed, 12 May 2021 20:40:59 GMT

I am trying to load a query from a Microsoft Access database into ArcPro 2.7. I have connected to the database no problem, loaded the query into ArcPro but when I attempt to open the query I receive the following error.

I am able to load other tables and queries from the same database without a problem. I narrowed it down to 1 field that was causing an issue. It has Domain as the field name. If I rename the field to Domain2 in the database and try to load it in ArcPro it works fine. Any ideas why this is happening? Is it a bug?

I am not the owner of the database so I don't get to chose the field names. Thanks,

Re: Load .accdb query with field name Domain

Anonymous User — Wed, 12 May 2021 23:49:14 GMT

Hi!

I expect that this is an Esri reserved word. There are some words that Esri 'reserves' that cannot be used in data schemas as they are essential in the underlying code. I did not find Domain in the documents below, but I definitely expect this to be a reserved word to prevent confusion between the functionality of Domains and the fields.

There is some reading here about reserved words - https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/defining-fields-in-tables.htm

https://pro.arcgis.com/en/pro-app/latest/tool-reference/tool-errors-and-warnings/010001-020000/tool-errors-and-warnings-10226-10250-010234.htm

https://support.esri.com/en/technical-article/000010906

Re: Load .accdb query with field name Domain

WilliamRice — Sun, 16 May 2021 20:26:51 GMT

Hi,

Could you describe how you are connecting to your Access database? Also, what version of Office are you using and is your version of Office 32 bit or 64 bit?
Thanks.

Re: Load .accdb query with field name Domain

sbrof — Mon, 17 May 2021 13:21:42 GMT

We use Office 365 64-bit. I am connecting to the access database using the create OLE DB Connection from the catalogue pane. I don't recall which provider I used but most likely the Microsoft Office 16.0 Access Database Engine OLE DB Provider.