Or you could just run the undocumented function to release it: CFUSION_DBCONNECTIONS_flush()
:-) Sharon DiOrio ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 12:32 PM Subject: A Tip (maybe new, maybe not) > I don't know if any of you work with Access much as a database here and there, but I >have been developing using an access database and had to upload it to our servers >after "looking" at the data or correcting the data as I was writing scripts ..well as >you all know it locks so you cannot FTP over it once it has been accessed. > > I would stop/start the cf service to get this to run, well it became a pain when my >terminal window would timeout and I would have to logg back into my server yadda >yadda. > > If you send a bogus query (one with an error), CF or Access will 'unlock' the file >for you... and you are back in FTP business. > > Many of you might already know this .. but we just figured it out and I thought it >was pretty slick! > > Paul Giesenhagen > QuillDesign ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists