Simultaneous users

[Martin Walke]

Hi,

Has anyone had any experience wrt simultaneous users of an access database
when accessed from a web page? I know that M$ seem to think that the limit
is 255 but from a practical side it seems to vary from 10 up to as many as
40 users , certainly not the 255 M$ are suggesting. Obviously if the number
of users increases too much I'll have to switch to SQL but from a licensing
issue Access will do the job as far as I know.

TIA
Martin

 

[Arvin Meyer]

My current data tables are accessed by 51 users concurrently. Six are using
Terminal Server, 9 a web server, and the other 36 are on several different
front-ends. We've been running at this capacity for the last 6 months or so,
but have been running with 42 or more users for the past 3 years.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Martin Walke]

Thanks for that Arvin.

I'm on more of a 'feeling out exercise' at the moment but have thought that
Access rather than SQL, and the cost issues that go with it, may work for 2
different projects that I'm looking at at the moment. In the past, I've had
trouble with VB accessing an MDB file due to lock up but that was easily
solved with back-off programming techniques.

Accessing an MDB via a browser, I thought wouldn't introduce those sort of
problems but was concerned about number of users. Thanks again for your
info.

Martin

 

[Arvin Meyer]

The only time I've ever had a severe problem with a browser access was a
report server that ran from a web page. It called a VB program running on
the server which fed a queue up database. The report took 30 seconds to run
and format, and impatient users kept clicking the button often a dozen times
or more. Every time they clicked a new entry was placed in the database.
Within a few minutes they corrupted it every time. We had to abandon the
project.

At a recent Microsoft Access conference that I attended a webmaster checked
his hit counter and found that the database had successfully returned 1417
inquiries in a 5 minute period. I wouldn't count on that, but that's what
was reported.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Martin Walke]

That clicking the button sounds like fun

Typical users...- Oh it's not doing anything so I'll click it a few more
times.. mind you we've probably all done it!

Martin