According to MS, Access 2000 can handle 356 (I believe) concurrent users and
10K rows. But I've seen folks here on the list claim to push the number of
rows way past 10K. I'd only use small web apps on it. The latest MDAC has
much less problems with memory leaks, as far as I know.
Dave
----- Original Message -----
From: "Owen Leonard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 8:47 AM
Subject: RE: limitations of Access
> Are these concerns specific to Access 97? What about Access 2000? I
> realize that in both cases we're talking about a "desktop application,"
> but small differences could make a big difference to a small company
> trying to decide.
>
> -- Owen
>
> ----
> Athens County Library Services
> http://www.athenscounty.lib.oh.us
>
> > -----Original Message-----
> > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> >
> > Access is a Desktop application and not a Server application
> >
> > Access has a 50 concurrent user limit - it errors as soon as
> > this is broken
> >
> > Access uses Table Locking, not Record Locking - so if you
> > want to update/add
> > a record, no other users can add/update to that table - this
> > is hellishly
> > important!
> >
> > Access's ODBC has memory leaks - it will mean the server must
> > regularly be
> > restarted
> >
> > Access isn't Transact SQL - this means you need 1 CFQuery per
> > query - if you
> > want to do tons of INSERT INTOs in a row, this slows up the template
> >
> > Access runs in the processor memory no matter which server
> > isn't on - this
> > means you can't have a separate database server to handle the
> > SQL and a CF
> > server to handle the templates
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
