I am trying to insert records into a Microsoft Dynamics database (SQL). I believe there is Referencial Integrity set up between two files.
I load the SQL Insert statement for one of the 2 tables then issue:
DoCmd.RunSQL sqlInsert (sqlInsert contains my insert statement)
I get "Microsoft Office Access ...and it didn't add 1 record(s) to the table due to key violations"
What is the best approach when inserting into 2 tables that have Referencial Integrity set?
I can go into SQL 2005 and insert a record without any kind of error? I am using Access 2007.
Thanks!
I load the SQL Insert statement for one of the 2 tables then issue:
DoCmd.RunSQL sqlInsert (sqlInsert contains my insert statement)
I get "Microsoft Office Access ...and it didn't add 1 record(s) to the table due to key violations"
What is the best approach when inserting into 2 tables that have Referencial Integrity set?
I can go into SQL 2005 and insert a record without any kind of error? I am using Access 2007.
Thanks!