Posted on 2011-03-11
Grateful for some assistance.
I have accidently populated an Access 2003 table with a complete set of identical records that already exist. In other words, the table has two of the same record in the table.
Is there a vba script that could separate the two records or delete a copy of the identical record.
So far I have converted the Access table into Excel and then individually delete the records one by one. Then importing it back.
I'm wondering if there is a simpler method, using VBA or MSAccess