MSDE ??? instead of access 2000?
----- Original Message -----
From: "Owen Leonard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 5: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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
