Hi Guys,
We have about 11,000 MDB files that need to have some records that are older than 12 months archived out. I've run through the Guides and manually create an Append Query and Delete Query but this will obviously take some time to do every database manually. Is there an easy way to script he Queries so that we can just run a batch file that will open each file and run the queries and then close again??
Thanks for your help in advance.
Regards,
Dave