As I understand it, disabling that setting is the recommended best practice for Access. Keeps things from crashing outright, so in this narrow circumstance there is no downside. An article on this was in the KB somewhere. It was entitled along the lines of ''using access in production environments''. I couldn't find it by searching for "access".
Whatever happened to the plain ol' KB? Did it get absorbed into something? I couldn't even find the thing on the MM site. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] Sent: Wednesday, November 06, 2002 7:43 AM To: CF-Talk Subject: Downside to disabling "Maintain Database Connections I posted a note yesterday re several sites running veeerrrrrrrry slow on a server. I have a couple sites that are MS Access databases. I am in the process of moving these to SQL but in the interim I need to keep the sites up. I found that by disabling the "Maintain Database Connections" setting in the ODBC configuration for these Access databases that it seems to take care of the problem for the most part. I am just wondering what the downside is to disabling that setting? Thanks for advice. Paul Sinclair ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
