File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes MSAccess database in my application Regarding Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MSAccess database in my application Regarding" Watch "MSAccess database in my application Regarding" New topic

MSAccess database in my application Regarding

sriram krishna

Joined: Nov 21, 2011
Posts: 6

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.

Thank you.
Keith Rainey
Ranch Hand

Joined: Jan 19, 2011
Posts: 66

I you are not finding any documented test results on using MSAccess databases, you can perform your own tests. You are probably the best judge of whether the performance is acceptable for you.

Build a test app to insert/modify/search/delete records and take time measurements of each operation with a wide variation in the number of records affected.

Keith Rainey
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

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.
sriram krishna

Joined: Nov 21, 2011
Posts: 6
Thank you.
I agree. Here's the link:
subject: MSAccess database in my application Regarding
It's not a secret anymore!