My application is a single user, stand alone application. I just want to use access database for this. Of course, there are many java related databases for this purpose which are better than access. I have searched for the details of access database and jdbc-odbc bridge driver in sun's websites, google and in this forum also. So many people are suggesting that access is the last case to use. Luckily mine is single user application, with single connection to the database, and perfectly matches to my requirement.
At last i have a question in my mind about the bridge driver. Is the bridge driver will be a bottle neck when the table rows in access database goes in the order of thousands?? please add any points if i have missed regarding the access database to your answers.
Of course it's a bottleneck -- in the sense that the data is constrained to go through it and you have to wait while that happens. But that is true of all databases, so really, asking whether it's a bottleneck is rather useless.
However perhaps the question you really wanted to ask is "Is Access combined with the JDBC-ODBC bridge driver going to be fast enough to satisfy me?" In which case Keith Rainey has already provided a full answer to that question, I believe.