about multi user

[Guest]

Hi,

I am developing a web application using ASP and Access. I am worrying about
the multi user issue of the Access database.

About how many concurrent user could Access supoort?

I also concerning whether any user could get error of record locking by the
others. But in my application, each user has his own set of records to read
and modify. Could this problem be avoided?

Could anyone who got similar experience give me some comments? Thank you
very much!

 

[Roger Carlson]

Each instance creates a separate connection to the database, so the maximum
is 255. However, a single use may have multiple connections, so the actual
number of users is lower. In addition, you may see performance problems
even before this number is reached. Access is a fine db for low-volume
websites or for development. But if you want higher volume, you're better
off with SQL Server. (Possibly MySQL as well, but I don't have any direct
experience with this to comment further.)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Tony Toews]

Each instance creates a separate connection to the database, so the maximum
is 255. However, a single use may have multiple connections, so the actual
number of users is lower. In addition, you may see performance problems
even before this number is reached. Access is a fine db for low-volume
websites or for development. But if you want higher volume, you're better
off with SQL Server. (Possibly MySQL as well, but I don't have any direct
experience with this to comment further.)

Note that the volume problems are more likely if there are lots of
inserts or updates. If most of the visits are read only then it can
handle a lot more traffic.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm