> As far as CF is concerned, this is pure urban legend: there is only one user: > CF, and VBscript is out of the way. > Only the jet engine is used. > I've been using Access databases since 1995 and I've never ever seen any > problem with them.
Well, no. While the dangers of Access tend to be exaggerated on here, I've seen plenty of problems with them personally. The problems with Access have nothing to do with VBScript or Access Forms, and everything to do with the fact that there's no real RDBMS behind Access. For example, if you use Client variables and store them in an Access database, don't be surprised if you end up with a 2 GB database file with 500 records in it. As you might imagine, that doesn't perform very well. The bigger problem, though, is that Jet isn't really designed for a high-volume multiple user environment. Dave Watts, CTO, Fig Leaf Software 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:344992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
