I have a sql server 2008 backend with an Access 2007 frontend database. Each time I export a query I get the following error: Microsoft Access was unable to append all the data to the table.The contents of fields in 0 record(s) were deleted, and 1 record(s) were lost due to key violations.*If data was deleted, the data you pasted or imported doesn't match the field data types or the FieldSize property in the destination table.*If records were lost, either the records you pasted contain primary key values that already exist in the destination table, or they violate referential integrity rules for a relationship defined between tables. Do you want to proceed anyway?
I don't know what if anything is actually missing because of the amount of data is more thant 6000 records. It seems everything exported but I would have to comb throug the data to be sure. Can anyone shed some light on why Im getting this error and where I might start to see if anything is missing.Thanks
exporting error
Posted - 2012-06-29 : 22:10:21