topic Re: Python - insert records to MS Access - error in Python Questions https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325704#M25340 <HTML><HEAD></HEAD><BODY><P>ArcMap - Python 2.7</P></BODY></HTML> Thu, 05 Apr 2018 20:33:04 GMT RobertMEIER 2018-04-05T20:33:04Z Python - insert records to MS Access - error https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325702#M25338 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P>RuntimeError: ERROR 999999: Error executing function.<BR />You cannot add or change a record because a related record is required in table 'Valid_Locations'</P><P></P><P>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.</P><P></P><P>So any ideas?</P><P></P><P>I get this error whether I use the Append tool/command and field mappings,etc. or using an InsertCursor.</P></BODY></HTML> Thu, 05 Apr 2018 20:05:30 GMT https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325702#M25338 RobertMEIER 2018-04-05T20:05:30Z Re: Python - insert records to MS Access - error https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325703#M25339 <HTML><HEAD></HEAD><BODY><P>arcmap or pro?</P></BODY></HTML> Thu, 05 Apr 2018 20:31:09 GMT https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325703#M25339 DanPatterson_Retired 2018-04-05T20:31:09Z Re: Python - insert records to MS Access - error https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325704#M25340 <HTML><HEAD></HEAD><BODY><P>ArcMap - Python 2.7</P></BODY></HTML> Thu, 05 Apr 2018 20:33:04 GMT https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325704#M25340 RobertMEIER 2018-04-05T20:33:04Z Re: Python - insert records to MS Access - error https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325705#M25341 <HTML><HEAD></HEAD><BODY><P>sorry for the post - my insert cursor code was wrong, I was trying to insert the row before setting all the values. Once I fixed that, I was able to add the rows without error.</P><P></P><P>Still don't know why the Append tool won't work.</P></BODY></HTML> Thu, 05 Apr 2018 21:19:37 GMT https://community.esri.com/t5/python-questions/python-insert-records-to-ms-access-error/m-p/325705#M25341 RobertMEIER 2018-04-05T21:19:37Z