I should read the rest of the responses first but. But another trick is to set your datasource to one MDB which links to the MDB database which will be uploaded on occasion.
Eric From: "Paul Giesenhagen" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: A Tip (maybe new, maybe not) Date: Thu, 16 May 2002 11:32:09 -0500 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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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