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 ?
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
Joined: Oct 30, 2000
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 ?
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