If you're using an Access database, and that's the lock you're trying to release, just run a query that will definitely fail, and that will release the lock on the file.
Example: SELECT badColumn FROM badTable Since that table (hopefully!) doesn't exist, the lock will be released on the database file and you will be able to overwrite it. Hope this helps, Dave. ----Original Message Follows---- From: "Douglas Brown" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: Release Database Date: Thu, 7 Feb 2002 10:18:22 -0800 What are you using for you DB? You can simply right click on the DB in SQL and choose take offline. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Graham Lewis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:56 AM Subject: Release Database > I find that I cannot overwrite a database file since it appears that CF > has it locked. How can I release it so I can overwrite it? > > Graham > > Graham Lewis > Centre for Academic Practice > University of Warwick > CV4 7AL > Tel: 024 765 73109 > Mobile: 07733450022 > 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 > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
