> > there are potentially many connections, > > like in any database system.
Right. But other database systems can handle concurrency much better than Access can. That's why people generally recommend not to use Access in high-concurrency situations. > > so the fact that it's only one user is irrelevant - > > It is, because the principal argument of Access detractor is that it is not > good in a "multiuser environment". And that argument is fundamentally correct, because what most people mean when they talk about multiuser database environments is the ability to support multiple concurrent connections. The distinction between users and connections is meaningless if your concern is concurrency. And in these environments, the web application is typically acting as a multiplexer of sorts - it uses its own credentials to support multiple web users simultaneously. A web application is by its very nature a multiuser environment. > > you still have concurrency issues. > > like with any database system. No, not like with any database system. Most RDBMSs handle concurrency better than Access does. > Access is a very economical and efficient solution for small or medium > applications. It's no more economical than MySQL, the free version of MS SQL Server, or Postgres. It's not especially efficient for web applications due to file locking, lack of ability to remove unused space for deleted records, etc, etc. > In large applications the problem is not with Access, the problem is with the > designer who chose the wrong solution. If you're building a web application and you choose Access, you chose the wrong solution. It may not be the end of the world, but it's not the best choice for any web application. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
