Removing Duplicates from Access table with Excel VBA

Hey everyone,

I've got a little challenge here. What I'm trying to accomplish is use Excel vba to remove of any duplicated records in an Access table and leaving just the one. I've tried using the script below but to now avail. What am I missing?

Here are the fields to my table.
fldID = Autonumber
fldDate
fldAccountName
fldUnknown

In design view the fldID field I guess would be considered position 0 since its the first field in the db.
If that's true then , fldUnknown would be postion 2, fldAccountName would be position 3, and fldDate would be position 5,

Please Login or Register  to view this content.