Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF.
jon Paul Giesenhagen wrote: > 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! ______________________________________________________________________ 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