Delete Query

Hello,

I'm working on a database that has 300,000 plus lines. I need to delete duplicate lines, my question is how would i do a delete query to remove duplicate lines without removing both lines with no primary key established.

Thanks,
George

Here is some code which is related to your problem. In this particular code
two recordsets are used, one being a clone of the other. When a duplicate record is found, it is deleted from the first recordset and the next record is examined. When it has determined that the records do not match, both recordsets are advanced
Try this code in your module

Please Login or Register  to view this content.