in reply to Accessing lots of Access Databases

Here is a sneaky way that takes advantage of the fact that there is one access DB per file: no more, no less.

  1. Get a list of your databases
  2. Copy the first DB to temp.mdb
  3. Create an ODBC to temp.mdb
  4. Process temp.mdb as needed
  5. Close the DB connect ($dbh->disconnect())
  6. Delete the DB (unlink(temp.mdb))
  7. Copy the next DB to temp.mdb
  8. Loop....

Hope it helps!

-Tats