AnsweredAssumed Answered

Python - insert records to MS Access - error

Question asked by rwmeier on Apr 5, 2018
Latest reply on Apr 5, 2018 by rwmeier

I'm trying to use Python arcpy to append records to an MS Access table, from a feature class. I keep running into the error:


RuntimeError: ERROR 999999: Error executing function.
You cannot add or change a record because a related record is required in table 'Valid_Locations'


Where 'Valid_Locations' is a related LookUp table. I understand the relationship/referential integrity, etc. I am not inserting a value that is not in the lookup table.


So any ideas?


I get this error whether I use the Append tool/command and field mappings,etc. or using an InsertCursor.