Here's a great link to an on going issue that I've continued to experience with some of our legacy applications. When using the JDBC / ODBC driver for a connection to the MS Access databases we encounter errors in regards to how many tables we can have open at one time. This article explains that its not that we are doing things wrong or at least totally wrong. Jim -----Original Message----- From: Mahfouz, Adnan Sent: October 27, 2011 11:34 To: Corbett, James Subject: check this one out http://stackoverflow.com/questions/1807934/ms-access-cant-open-any-more-tables-using-jdbcodbcdriver Adnan Mahfouz Programmer/Analyst GST-HST (GST Micro)/TPS-TVH (Micro TPS) 875 Heron Rd., H2-58 613-941-1339