How do I repeat a process for many db's?

[greaseman]

I have about 125 .mdb's I want to go through, and in each one, select a table and run a "find duplicates" query, creating a table of duplicate record info for research into why there are duplicates.. I am aware I can manually do this within each .mdb, but would be happy to be able to automate the process.

I wasn't sure what to search for, which is the reason for my posting. If anyone has an idea (and not questions on why I want to do this, or probs. I might encounter), I would be most appreciative.

Thanks!

 

[supercharge]

I'm just brainstorming this. One way to accomplish it is to create a new .mdb; link all others tables and run a macro. The linking part might take a while too unless it can be automatically done also which I think is doable, isn't it?

 

[greaseman]

supercharge,

Thanks for replying, but I don't think that would help for what I want. Yes, I could link all .mdb's, but then I would still need indiviual queries for each table, since all the names would be different. So, the results would be the same as running the job once for each .mdb, since I'd have to have individula queries for each .mdb.

I'm more interested in some type of recursive code that would "go through" all my sub-folders, place the respective .mdb names into a generic piece of code, check for dupes, creating a table fo dupe data along the way and looping through the whole process until all files are done.

Any other takers out there??

 

[supercharge]

How about naming your other databases systematically then use a loop to loop thru it?

 

[greaseman]

Can't do that either..... powers that be indicated they would scream if files have different names. Oh, well..... I've just been doing them manually, by creating a "find duplicates" query and importing it into each .mdb. Cumbersome, but it's working and I'm about halfway done.

Thanks for your replies..... have a good day!