Here is a sneaky way that takes advantage of the fact that there is one access DB per file: no more, no less.
- Get a list of your databases
- Copy the first DB to temp.mdb
- Create an ODBC to temp.mdb
- Process temp.mdb as needed
- Close the DB connect ($dbh->disconnect())
- Delete the DB (unlink(temp.mdb))
- Copy the next DB to temp.mdb
- Loop....
Hope it helps!
-Tats