dot said:
i use access with asp for some small websites, i need to
make a big website now, 5000+ registered users, forum,
etc. can i use 1 access.mdb for this ? how many records
can access handle and still be quick, and what is the
filessize than ?
Access is a file-server database not a client/server one. The addition of a
server like IIS or ColdFusion turns it into a client/server. It is not the
number of records as much as it is the number of hits. I had one intranet
application which returned an Access snapshot that took about 30 seconds to
run. There were only 6 users but they were impatient, when they didn't get
their report within a few seconds, they hit the button again and again. The
net result was that within a few minutes they'd crash and corrupt the
database.
I'd advise that you take a look at the actual traffic on the site. The JET
engine will handle 5000 users if, and only if, the database is well designed
and the users are not trying to access the data in concentrated effort.
Since you also can't guarantee that there will not be growth, I'd say you
should be looking for a more robust engine for your usage. I've used
SQL-Server on a site with 50,000 daily hits with no problems.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
