Just to balance out the conversation, a couple years ago we had developed an 
e-commerce site which was to be prototyped in Access, then moved to SQL Server for 
production. The client decided that they didn't want to pay for the move to SQL 
Server, so we launched with Access as the backend. The database had tables containing 
from several hundred records, to over 100,000 records. The site grew in popularity and 
regularly recieved 10s of thousands of page views per day, each page having up to 10 
or 15 database queries. Before moving to MS SQL Server a year later, we never had a 
single problem with Access. Not one.

Now, that's not *huge* traffic, and I wouldn't recommend trying it today, but it 
certainly suprised me.

--
Jack Baty
Fusionary Media




---------- Original Message ----------------------------------
From: "Tyrone Mills" <[EMAIL PROTECTED]>
Date: Fri, 22 Jun 2001 11:43:51 -0700

>Sounds like you could be a reference site for Microsoft!! Only 2 corruptions
>using Access multi-user. That's incredibly good. I've supported systems with
>only 3 concurrent users who suffered corruption on a nearly daily basis.
>
>----- Original Message -----
>From: "John Meyer" <[EMAIL PROTECTED]>
>To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
>Sent: Friday, June 22, 2001 10:16 AM
>Subject: Re: ACCESS DB, and MySQL which one better to handle database driv
>en webpage
>
>
>> It only corrupted your database twice?
>>
>> On Friday 22 June 2001 09:50, Patrick Calkins wrote:
>>
>> > MySQL can handle infinately more concurent connections to it, and handle
>a
>> > much bigger load than MDB can even dream of doing. A few years back I
>used
>> > to write database apps in visual basic and MDB. It was running on the
>> > network, with only about 5 people accessing it at one time. MDB had
>> > corrupted the files at least twice.
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>>    http://www.mysql.com/manual.php   (the manual)
>>    http://lists.mysql.com/           (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to