This has not worked since CF5 i'm afriad. On Thu, Sep 16, 2010 at 12:56 PM, Bobby Hartsfield <[email protected]>wrote:
> > 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:337110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
