Just send it a junk SQL statement. For example: <cfquery name="unlockmdb" datasource="datasourceName"> SELECT blah FROM blah </cfquery>
It will return an error, but the lock should be gone. "Kris Pilles" <[EMAIL PROTECTED]> wrote in message E7B536D0EE4BD51197B0009027724CE1C5999F@ADMIN-EXCHANGE">news:E7B536D0EE4BD51197B0009027724CE1C5999F@ADMIN-EXCHANGE... > Anyone know how to release all locks on an access database via coldfusion? > > I am having some trouble with getting one of our datasources to release its > current locking thus preventing me from uploading a new copy of the DB. > > > Thanks for your help > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
