This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes MS Access 2000 on web Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS Access 2000 on web" Watch "MS Access 2000 on web" New topic
Author

MS Access 2000 on web

jayram
Ranch Hand

Joined: Oct 30, 2000
Posts: 94
Hello
One of our clients wants to use MS Access 2000 database as backend for one of his web based applications. According my knowledge till Access 98 ..MS Access didnt allow multi user access and used to do a database lock for each user access. Is this thing rectified in MS Access 2000
Are there any other reasons why MS Access should not be used on web??
I remember a similar discussion here but couldnt find the link
TIY
Cheers
Jayram
------------------
What if this is as good as it gets ?
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
MS Access does not scale well for major applications. Especially when you have more than 4 - 5 concurrent users.

Bosun


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
Seconded. Access is a fine GUI front-end tool, but can't be taken seriously as a multi-user database. If you don't have any money to spend, check out PostgreSQL or MySQL.
- Peter
jayram
Ranch Hand

Joined: Oct 30, 2000
Posts: 94
hello ..
yeh i know and agree to all these points but i want to provide a documentary proof of this ...like a link or maybe some sort of article/white paper any written stuff which says why and how.
Do you have any links which provide detailed article or something on this topic??
Cheers
Jayram
------------------
What if this is as good as it gets ?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

If your not willing to fork out $$$ for a database, you probably aren't going to fork out $$$ for a JDBC driver. Here is a link to some problems that the jdbc dbc bridge (free driver included with the JDK) has to offer you:
http://java.sun.com/products/jdbc/faq.html
most notably questions 2, 20, 21
not to mention all the programming problems that seem to occur when people program using the bridge and MSAccess.
Jamie
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MS Access 2000 on web