Load .accdb query with field name Domain

607
3
05-12-2021 01:40 PM
Labels (1)
sbrof
by
New Contributor II

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.

sbrof_0-1620851712681.png

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,

0 Kudos
3 Replies
AngelaMarsh1
Esri Contributor

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.h...

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

 

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

 

 

Happy Mapping
WilliamRice
Occasional Contributor II

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.

0 Kudos
sbrof
by
New Contributor II

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.

0 Kudos