append query key violations

  • Thread starter Thread starter Jacquie
  • Start date Start date
J

Jacquie

I need to run a query that appends records from a table to the exact same
table in another database. I run it, and it it refuses to add the new records
saying that there are key violations. And yet if I do a copy and paste
append, it will work.

I've done all the obvious -- made sure the primary key wasn't duplicated,
made sure referential integrity wasn't violated, etc.

Any ideas? thanks!
 
INSERT INTO Students ( UI, IDCon, FName, LName, BusEmail, Address, City,
State, Zip, Zip4, EMail, IndPhone, CellPhone, DayPhone, CareType, Comments,
FCCCertified, CountyContract, HomeCenter, Business, BusAddress, BusCity,
BusState, BusZip, BusZip4, BusFax, DOB, SID, BusPhone, BMonth, BDay, OELov,
ITov, NEW ) IN 'K:\CCC Database.mdb'
SELECT iStudents.UI, iStudents.IDCon, iStudents.FName, iStudents.LName,
iStudents.BusEmail, iStudents.Address, iStudents.City, iStudents.State,
iStudents.Zip, iStudents.Zip4, iStudents.EMail, iStudents.IndPhone,
iStudents.CellPhone, iStudents.DayPhone, iStudents.CareType,
iStudents.Comments, iStudents.FCCCertified, iStudents.CountyContract,
iStudents.HomeCenter, iStudents.Business, iStudents.BusAddress,
iStudents.BusCity, iStudents.BusState, iStudents.BusZip, iStudents.BusZip4,
iStudents.BusFax, iStudents.DOB, iStudents.SID, iStudents.BusPhone,
iStudents.BMonth, iStudents.BDay, iStudents.OELov, iStudents.ITov,
iStudents.NEW
FROM iStudents;
 
Jacquie,

I am very sorry, what you have done seems straightforward, and I can't
think of why you are getting this error.

Can you please re-post your question to the Queries newsgroup, as it
will more likely get seen by a wider group of people over there.
 
Back
Top