Quote:
|
Originally Posted by JinnKai
MS Access is the bottom of the DB food chain. It works, but it's terrible for anything beyond a small (40ish) user base.
|
Wow, that's generous. I've seen Access applications grind to a halt with three users and less than 10k records. Nobody should be using it for anything more demanding than organizing recipes or keeping a catalog of CDs.
However, it does make a very usable interface to a real database over ODBC. I have a client who interfaces with MySQL on his web server over Access/ODBC, and it works great for him. There's latency, since the data is over the Internet rather than right there on disc, but the app itself is rock solid.