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:337075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
