My append queries delete some of the new records in the appended tables (in a different database). The records that are being deleted differ from the old records by a one or few characters or numbers
(ie. (1402-PK) "Ambulance" - old record and
(90005-PK) "Ambulance1" - new record
-> result (90005) "Ambulance" or there would not be an "Ambulance1" record in the appended table at all).
Do you know why it is happening?
Thanks
(ie. (1402-PK) "Ambulance" - old record and
(90005-PK) "Ambulance1" - new record
-> result (90005) "Ambulance" or there would not be an "Ambulance1" record in the appended table at all).
Do you know why it is happening?
Thanks
