When I run an append query that deletes duplicates in a table, an error message comes up saying,"Microsoft Access can't append all the records in the append query." The error message is just telling me that some of the records will be deleted, which makes sense, seeing as I want it to delete all of the duplicates. I need to run this append query on a daily basis, and I am curious if there is any way I can keep this error message from coming up? I have a feeling it is something that cannot be fixed.