> >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.
While there is only one user account, there are potentially many connections, so the fact that it's only one user is irrelevant - you still have concurrency issues. You also have other problems, such as the inability of Access to perform routine table maintenance while the database is being used by CF. For example, the space originally allocated for records isn't reclaimed properly when the records are deleted. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:358815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
