What usually I do is upload the database to a new name and change the ODBC connection to point to the new file.
-- Sam -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:25 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker .... thanks! Paul Giesenhagen QuillDesign > There is an undocumented CF Function that will do the same thing. > > CFUSION_DBCONNECTIONS_FLUSH() > > I used to use the bogus query to do this as well until I found out about > this function. > > Cheers! > > -- > Scott Van Vliet > Sempra Energy > 555 W. 5th St., 21st Floor > Los Angeles, CA 90013 > Tel > 213.244.5205 > Email > [EMAIL PROTECTED] > > "Hello Stupid, and welcome to your crappy computer." > - Strong Bad, HomestarRunner.com > > > > > > > > -----Original Message----- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, May 16, 2002 9:32 AM > > To: CF-Talk > > 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 > > > > > > > ______________________________________________________________________ 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 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
