MS Access

[Adage]

Bare with me I am a little new to this. I am taking a DB maintained in My SQL and transfering it to MS Access. What I am looking for is a way to remove duplicate records in the database using MS Access. Any suggestions?

[Johnny101]

I would suggest filtering them out before they get to the access db.

you could write a little vb app to extract the data from the old database and put it into the new one. On your select statement from the old db, use DISTINCT to ensure that no duplicates are chosen. then with this unique recordset, insert each row into the new database. this would of course be in a loop.

hope this helps/applies.

John

John Pirkey
MCSD
www.ShallowWaterSystems.com

[Johnny101]

I forgot to mention that there is a "Find Duplicates" Query Wizard in Access. After you get the information into the access table, go the Query tab and select New, then in the list of wizards, there should be a "Find Duplicates Query Wizard" entry. Choose that and then follow the instructions.

Hope this helps,

John

John Pirkey
MCSD
www.ShallowWaterSystems.com

[Tony Lin]

My suggestion would be to use a "find duplicate records" query in access which you can create through the query wizard. You can set this up onto an event which is going to fire evertime you need it to...ie a forms "on load" event.