What are the limitations of MS Access?
It’s no secret: I do not trust Access. I don’t think it should be used in a production environment for anything more than a personal website, and an unpopular one at that. If you’re building a web site that you expect will be even remotely successful, you’re only delaying the inevitable by using Access now. You will eventually be forced to upgrade to SQL Server (or something similar). I have many reasons for this, most from first- or second-hand experience. I’m not going to get into all of those right now, because it is somewhat biased by my experience, and the type of applications I specialize in (which may vary from the typical web developer). I’ve received criticism that this article is “horribly biased” and that if I can’t get Access to work in a high-volume system, I must be a “shoddy programmer.” Admittedly, much of the *official* information here comes from the horse’s own mouth (mainly knowledge base articles admitting Access’ weaknesses); however, the whole purpose of the arti
