bottom line: Access sucks unless your inventorying a CD collection.
On Thu, Jul 3, 2014 at 2:49 PM, <> wrote: > > >>But transfer the data to an actual database > > I was expecting this clever answer! ;-) > Access has a bad reputation in a LAN multiuser APPLICATION. > But it is only when the application is also an Access application. > All requests cause many accesses to the disk, both for code and for data, > which causes a bottleneck. > In a coldFusion application, the application is NOT stored in the same > file as the database, > and there is only ONE user: Coldfusion is the user. > > I've noticed that since I have my database installed on Windows 7, locks > are even more capricious than before if you open the database in the same > time you run a CF application, and this does not come from Access. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
