Append query

[tjisaacs]

I have a database linked to a table. I am trying to append this data to a table in my databse. I am getting this error

unable to append 36 records to table due to key violations

I know there are duplicate records in the linked table and am sure that is the cause of my error. I want the duplicates to append, how can I fix this>

 

[smedvid]

Review the design of the database table that you are attempting to append to...

Remove the primayr key and check each field to see how the index is setup or if there is another validation rule in place.

htwh, ;-) Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...