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.