CODEWITHSUNDEEP
ms-access
Cris
Cris

Reputation: 12194

Microsoft Access as web DB

I know, we are in 2011 and not in 1998. But a customer asked to make a web site in ASP vs. an Access DB. I've read many bad things but I would really like what are the limitations of Access (after 2003) and the real reasons why not to use it (are their limitations on max concurrent user access? Is it unscalable? Breakable? etc.).

Upvotes: 0

Views: 257

Answers (3)

Tony Toews
Tony Toews

Reputation: 7882

If the website is mostly read only with relatively few inserts/updates then Access will work reasonably well. One example might be a real estate website where a few listings per hour are added/updated.

Upvotes: 1

Fionnuala
Fionnuala

Reputation: 91316

You can use Access 2010 to build websites with Sharepoint: http://www.youtube.com/watch?v=AU4mH0jPntI

Otherwise, it is unlikely to be a good idea, unless you are thinking of a private website, it which case it is do-able, with care, but still, not necessarily a good idea.

This document contains an interesting table of limitations etc

Upvotes: 1

Linora
Linora

Reputation: 10988

Generally speaking MS Access is not appropriate for a large scale application. However it is just fine for smaller applications which doesnt handle many users simultaneously. Often MS Access is disregarded if the application has 10+ simultaneous users.

I dont know if it has a max connections, but I have heard that 16 is the limit, but others say 20 and some say there isnt a real limit

Upvotes: 0

Related Questions