Be aware that the JDBC/ODBC driver is buggy and not thread-safe. If you have to use Access in a concurrent environment (why?), at least use a decent driver (like HXTT). Or -much better- use a DB that's made for concurrency (SQLServer, PostgreSQL, MySQL, etc.).
Mohnish Khiani wrote:I have used microsoft access as a database in my program and sometimes i get the exception:
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
Why does this happen..and what do i do to avoid it?
you should close your all db connection properly... close your resultset (if you have used) using close() method of ResultSet class and close your statement object using close() method of Statement; this all should be done in finally block.. closing all db stuffs is always best practice.
Life is either daring something or nothing - Helen Keller