In the CF admin, make sure "Maintain Database Connection" is not checked. That should help. www.easycfm.com also has some very nice, quick tutorials on how to create CFM pages that can add/delete data from the db without having to FTP it.
Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] Do you want complete ColdFusion Administrator access? RDS? Terminal Server?- CFX-Advanced VPS - http://www.cfxhosting.com/Plans/s_cfxadvancedVPS.cfm -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 11:35 AM To: CF-Talk Subject: Extremely Persistant Access "ldb" Lock File This one has got a client almost in tears. There's a large Access file which a client needs to update twice a day by ftp'ing a new version in (Hey, I tried to convince them to use SQL...). Problem is, there's a persistent "ldb" on the database that almost NOTHING can seem to make go away. So, when time comes to ftp a new database, they can't - the file is locked - for hours and hours at a time, even if nobody is accessing the site and using the database. Evening putting one of my "breakconnection.cfm" files out there that purposely errors to break the connection won't kill it. They've got the "timeout" set in the CF Admin to 1 minute. Ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
