Use Access as web database?

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I create an ASP that connect to a Ms-Access database (with ADO) in my web
server (win 2003 server).
Any body has experience about the number of concurrent connections (ASP
execution) to the MS-Access 2000 database ?
Is there any limitation for this?
Detail :
How many request(query) it can support for a database (10 MB) concurrently?

Any information would be appreciated.
Thank you,
Zargar
 
I run one website that uses Access on a 60 MB database that gets as high as
5000 well distributed hits per day. Other than needing the JET SP4 installed
some time ago, it has never hiccupped. The server is a Dell P4 800 with a GB
of RAM running IIS 5.0 on Windows 2000, fully patched. I've heard reports of
Access handling significantly more than that.

The key is in distribution. Access is not, by nature, a server database, so
it has trouble handling lots of concurrent requests. I was able to
frequently kill (corrupt) a small (2 MB) database with a constant barrage of
hits even at 2 or 3 per second for about a minute.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top