It's ok. It's been a while for me too. I havent touched Access in any way for any reason since way back in the mid 90s. Now i have to use it because of a legacy of LOTS of point of sale terminals that all use it for importing updates into their systems.
My hope is that we'll get rid of this application pretty soon. But in the mean time I'm stuck with it. Cheers Mike Kear On Thu, Sep 16, 2010 at 3:30 AM, Will Swain <[email protected]> wrote: > > Sorry - like I said, it's been a while. > > > -----Original Message----- > From: Mike Kear [mailto:[email protected]] > Sent: 15 September 2010 18:21 > To: cf-talk > Subject: Re: Is there a way to force lock release on Access database? (CF9) > > > Yes, that's what i used to do too, Will. But that was in the CF5 > days. With MX that stopped doing the trick. > > Cheers > Mike Kear > > > On Thu, Sep 16, 2010 at 2:39 AM, Will Swain <[email protected]> wrote: >> >> We used to have to create a 'bad' connection by querying a non-existent >> table or something. That would break the connection and release the .ldb. >> This was years ago though. >> >> Will >> >> -----Original Message----- >> From: Rick Root [mailto:[email protected]] >> Sent: 15 September 2010 17:31 >> To: cf-talk >> Subject: Re: Is there a way to force lock release on Access database? > (CF9) >> >> >> On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels <[email protected]> > wrote: >>> >>> unchecking the "maintain database connections" in the DSN may work. >> >> WE used to do this back in the 90s when I was still using Access >> databases for web sites :) >> >> Rick >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:337087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
