This is a bit of a bubblegum solution, but you can have your client run a lock killing query just prior to upload. Just setup a quesry that they can navigate to in their browser (I call it qLockKiller.cfm). The SQL should be something like "SELECT something FROM nothing". That will cause a db error and unlock Access (remove the .ldb file). Sometimes the query needs to be run afew times. I'd suggest doing this at non-peak times as somebody could hit the db again in the time it takes to fire up the FTP and send up the db.
All that said...clients should not mess with uploading databases over top live ones...transaction will inevitably happen between the download and upload and thus data will be lost. Best solution is to set CF admin to only allow SELECT statements durring this process so no data can be altered. Of course this requires access to CF admin which is not always easy if hosted in a shared environment. HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com ----- Original Message ----- From: "John McKown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 12:36 PM Subject: Disconnecting Data Sources for Upload? > Customer has Access database that he uploads to CF Server via FTP. > Access database is a datasource for his site. > When site is being viewed, he cannot upload a newer copy of the database > because the file is locked. > > Any creative solutions besides "disconnect the datasource"? > > John McKown, President > Delaware.Net, Inc. > 28 Old Rudnick Lane > Dover, DE 19901 > e-mail: [EMAIL PROTECTED] > phone: 302-736-5515 > toll free: 888-432-7965 > fax: 302-736-5945 > cell: 302-363-0071 > icq: 1812513 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
