Can anyone help me out to tell if we can do connection pooling thro' JDBC-ODBC Bridge for Ms Access
which interfaces are to be used
You can always use Apache Jakarta's DBCP, can be found in http://jakarta.apache.org/commons/dbcp
I had very good experience with it.
Do bear in mind that MS Access itself only supports a small handful of connections (two, I think), so make your connection pool small.
In general MS Access should not be used for any application that needs to scale above a dozen or so users.