I have an issue where the appendcontactserverQ throws an error when I try to run it and it will not append the data. I have downloaded the most recent database and it appears identical. I was wondering if you could tell me what it wrong.
Bryce TervoOP
@Reply 3 years ago
Kevin Robertson
@Reply 3 years ago
Key violations - Are any of the fields indexed (No Duplicates)?
Bryce TervoOP
@Reply 3 years ago
Just ContactID is set to (No Duplicates). CustomerID is set to (Duplicates OK) and the rest are no.
Kevin Robertson
@Reply 3 years ago
Is ContactID being appended to the table (both AutoNumbers)?
Bryce TervoOP
@Reply 3 years ago
Yes, ContactID is being appended to the table and both are auto numbers. The table being appended to is empty when running the append.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 23.
