File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS Access 2000 on web" Watch "MS Access 2000 on web" New topic

MS Access 2000 on web

Ranch Hand

Joined: Oct 30, 2000
Posts: 94
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
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.


So much trouble in the world -- Bob Marley
Peter den Haan
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
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 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??
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:
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.
I agree. Here's the link:
subject: MS Access 2000 on web
Similar Threads
JSP/Servlet With MS Excel?
Connecting to MS Access 2000
Best JDBC drivers?
Major Dilemna
dns less ms access