>>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:358804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
