Access & Scaling

[Wynn Osborne <wynn@xxxxxxxxxx>]

It was wrote:
>Pete, what does "not scale very well" mean?  Are we to think of one or two
users, or 8, or 15, or 3,000?
>
>>They're not magic. My experience with Access has been that it doesn't
>>scale very well. It is, however, very compatible with SQL Server. I'll
>>bet this company is in for some stressful times.
>>Pete Hall

Forget the number users---how about number of row?!

Go throw about 250,000 rows into a table and try to browse it. Result: One
big old lazy dog!

Access is like the vast majority of other MS products. Nice toys.

Wynn

BTW, to answer the scaling question, I would say that Access could handle 2
users fine, 8...ehhhh...yes but with some hacking & coughing, 15? Only if
you like long coffee breaks whilst querying; 3000? We'll never see that in
our lifetime!
"Uhhh, Uhhh, ..., they uh"--Lance LeRoy

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---