don't blame you, its a very long and repetitive thread.
On Mon, Sep 20, 2010 at 10:21 PM, Mark A. Kruger <[email protected]>wrote: > > Russ.... uh... sorry - should have read the whole thread... and I wasn't > giving an answer really.. just being nostalgic :) > > Mark A. Kruger, MCSE, CFG > (402) 408-3733 ext 105 > Skype: markakruger > www.cfwebtools.com > www.coldfusionmuse.com > www.necfug.com > > > > -----Original Message----- > From: Russ Michaels [mailto:[email protected]] > Sent: Monday, September 20, 2010 4:14 PM > To: cf-talk > Subject: Re: The solution: (was: Re: Is there a way to force lock release > on > Access database? (CF9) ) > > > Your about the nth person to give that answer Mark. > as I said at the start, that hasn't worked since CF5. > > On Mon, Sep 20, 2010 at 4:48 PM, Mark A. Kruger > <[email protected]>wrote: > > > > > In the old days intentionally throwing a driver error would do it :) > > > > Mark A. Kruger, MCSE, CFG > > (402) 408-3733 ext 105 > > Skype: markakruger > > www.cfwebtools.com > > www.coldfusionmuse.com > > www.necfug.com > > > > > > > > -----Original Message----- > > From: Andrew Scott [mailto:[email protected]] > > Sent: Sunday, September 19, 2010 11:49 PM > > To: cf-talk > > Subject: RE: The solution: (was: Re: Is there a way to force lock release > > on > > Access database? (CF9) ) > > > > > > One could always use the Administrator API, and remove that setting from > > the > > admin settings. Whether this lock is changed on the request as easily is > > another story. > > > > Just a thought. > > > > Regards, > > Andrew Scott > > http://www.andyscott.id.au/ > > > > > > > > > -----Original Message----- > > > From: Mike Kear [mailto:[email protected]] > > > Sent: Monday, 20 September 2010 2:41 PM > > > To: cf-talk > > > Subject: The solution: (was: Re: Is there a way to force lock release > on > > Access > > > database? (CF9) ) > > > > > > > > > That would work too, Dave. I think! The second page would contain > > > the delete functionality? Seems to make sense. > > > > > > The problem is to force ColdFusion to let go of the datasource > completely > > > before attempting to delete the MDB file. I have found that using > > CFThread > > > wont work, because ColdFusion still hangs on to the datasource even > after > > > the .cfthread accessing it has completed. > > > > > > Later: ... > > > > > > I tried Dave Watts' suggestion of a CFLOCATION to a second page, and > > > it works on my development environment. PROGRESS! Thank you Dave. > > > > > > So the lesson to learn: > > > > > > [A] ColdFusion 9 retains a lock on an Access database for the entire > time > > a > > > page that requires it is active. Once the page finishes processing, > the > > lock is > > > automatically released on the access database. > > > PROVISO: you have to have set up the datasouce in the > CFAdministrator > > as > > > "-- Maintain connections across client requests." > > > set to Off (unchecked). I have not been doing any work on this with > > > that option On, so I can only assume it wont work with that option set. > > > > > > [B] causing an error, by running a query on a non-existent table wont > > release > > > the lock on the database post-CF5. That was the advice way back in the > > old > > > days, but now it wont work. In fact it'll be counter-productive > because > > it will > > > cause the connection to the dsn to persist even longer and therefore > > retain > > > the lock longer. > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:337242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
