Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Access 2000 on web

 
jayram
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MS Access does not scale well for major applications. Especially when you have more than 4 - 5 concurrent users.

Bosun
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic