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 why MS access not good ? 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 "why MS access not good ?" Watch "why MS access not good ?" New topic

why MS access not good ?

Rajeev Ravindran
Ranch Hand

Joined: Aug 27, 2002
Posts: 455
hi all,
For an web application I heard MS access cant support more than 10-15 users, but oracle and other RDBMS packages supports n number of users.. Could any1 tell me why access has this drawback ???

SCJP, SCWCD, SCBCD, Oracle Certified Professional (SQL n PL/SQL)
Tiberiu Paun

Joined: Sep 02, 2003
Posts: 10
I'm sorry to inform u that Oracle doesn't support more than 20-from what I know users simultanuously. It's not oracle's fault, but oracle driver's fault.
I know I made a JDBCConnection pool for oracle, and when I configured it for 20 users, it thrown me an exception with this topic.
However, u should use anything else but MS server. Try MySQL, is better.
We have a lot of applications, all of them do heavy selects in Oracle databases, none with the slightest problem.
The only application which uses MS SQL server has problems. And the database of it has only one table!!!
So if you use MS, than u r in trouble ...
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
WOW - that last post is full of bold statements.
Oracle supports thousands of concurrent users!
MS Access has problems based on the fact that it is very lightweight, and is a single file implementation. The ODBC driver tries to take care of this, but the database implementation in general is not meant for large scale enterprise applications.
MySQL is a great choice, and the new control center makes it great for newbies.
I agree. Here's the link:
subject: why MS access not good ?
It's not a secret anymore!