If I recall, when we would need to upload a new copy of an MDB it would say it was in use and not allow it. We would just run a bad query against it and then it would allow us to overwrite it. " Select 1 from soemTableThatDoesntExist"
Maybe that will work for you. It has been a loooooooong time since I used an Access database so it may or may not work anymore. There is also the "Suspend all client connections" setting within the CF Admin (there is for SQL Server datasources at least). I'm sure you can change that value programmatically through the admin API. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Mike Kear [mailto:[email protected]] Sent: Wednesday, September 15, 2010 11:58 AM To: cf-talk Subject: Is there a way to force lock release on Access database? (CF9) I have to make an Access database containing updated data from my SQLServer database, which can be downloaded by my users by FTP. I can make the Access database a coldfusion datasource, and fill it up with the data I want, but I need to release it from the lock ColdFusion puts on it. Does anyone have a technique for releasing that lock nowdays? (I'm using CF9 Enterprise). IN CF5, which is the last time i used Access with ColdFusion, it was a simple case of doing an invalid query but that doesnt work in MX days. There was a non-documented function once as well ... CFusion_DBConnections_Flush( ) ... but that's not valid in CF9. Has anyone found a way to break that connection programmatically in CF9? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
