I have an access database that is linked with sql server through ODBC. All workds fine, I can add records manually by openeing the tables and typing in data. But when I try to run an append qry, it gives me a "Didn't add 1 record due to a key violation". well, I have tried about every key combo I can think of (even none) to no avail.
Any ideas on this ever frustrating problem?
Thanks
Adam
Any ideas on this ever frustrating problem?
Thanks
Adam