>>There is very few reasons why you would want a Web App with Access. None of them that I can think of would be useful in a web app that is worked on by 2 or more people (which most web apps are).
1. Access is not sensitive to SQL injection. 2. Only one file for the whole database, the whole database can be moved in and out by a simple FTP transfer. 3. Searchable memo fields, Again, for small/medium applications, this is valuable. >>in a web app that is worked on by 2 or more people (which most web apps are). In CF Web applications there is only ONE user at a time on the database: ColdFusion. There may be several users in the CF application, but only one in the database: ColdFusion. If multiuser applications are not running properly, the problem is with the way the ColdFusion application is accessing the database file not with the datasource file per se. There is simply NO Access application on the Web, what is called an application is actually the code that makes it running. There is no Access code in a CF application using an Access database, only CF code. So everything you may have heard or read about "Access applications" is not applicable to access datasources under CF. I've been using Access datasources in small/medium application since ColdFusion 1.4, for more than 10 years, and I haven't encountered the slightest glitch imputable to the Access datasource. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
