This week's giveaway is in the Spring forum.
We're giving away four copies of Microservices Testing (Live Project) and have Chris Love & Andres Sacco on-line!
See this thread for details.
Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

MS Access 2000 on web

 
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?
 
Ranch Hand
Posts: 1512
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
author
Posts: 3252
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic