It's not elegant, but I've found that throwing an error on the datasource works for releasing them. Try a query against the dsn for a table that doesn't exist.
Cheers, Kris > Try deleting the .ldb file. > > On Wed, Sep 15, 2010 at 8:58 AM, Mike Kear <[email protected]> wrote: >> >> 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 Enter ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:337210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
