It's Access. Need we say more? (hehe) Actually I believe it has something to do with a combination of ODBC and Windows and the JET drivers. Other ODBC connections don't seem to lock that way but if you look really hard with google you can find a tool that will list the locks and what is holding them and another tool (in the same package) that lets you kill them, however the caveat I read years ago was that after doing that you immediately needed to run a clean and repair on the Access DB.
Steven Durette -----Original Message----- From: Ben [mailto:b...@webworldinc.com] Sent: Thursday, July 03, 2014 2:32 PM To: cf-talk Subject: Re: Locks on Access files in CF 9 Interesting. Probably more work than I want to out in unless needed. Anyone know why the lck file gets sticky? CF issue? ODBC issue in Windows? Just curious Ben > On Jul 3, 2014, at 11:15 AM, Scott Stewart <webmas...@sstwebworks.com> wrote: > > > You *could* put a system together where the client, or you uploads the > access database, the system programatically creates a datasource on the fly > transfers any data changes to the real database, kills the datasource and > deletes the access db, the client can do what he wants and you don't have > to deal with access lock file issues. > > >> On Thu, Jul 3, 2014 at 2:06 PM, Ben <b...@webworldinc.com> wrote: >> >> >> Yeah, you're preaching to the choir on that one. :) >> >> This client tweaks their copy of the DB with local apps then uploads it to >> the server. >> >> Ben >> >>>> On Jul 3, 2014, at 10:59 AM, Phillip Vector <vec...@mostdeadlygame.com> >>> wrote: >>> >>> >>> Not to be "That Guy"... But transfer the data to an actual database and >> use >>> that? >>> >>> >>>> On Thu, Jul 3, 2014 at 10:53 AM, Ben <b...@webworldinc.com> wrote: >>>> >>>> >>>> Sorry, didn't mention that. It is off. >>>> >>>> Ben >>>> >>>>>> On Jul 3, 2014, at 10:51 AM, Scott Stewart <webmas...@sstwebworks.com >>> >>>>> wrote: >>>>> >>>>> >>>>> Turn off maintain connections in the data source properties. >>>>>> On Jul 3, 2014 1:49 PM, "Ben" <b...@webworldinc.com> wrote: >>>>>> >>>>>> >>>>>> Hi >>>>>> >>>>>> I'm seeing an odd issue where a .lck file doesn't go away at times on >> an >>>>>> Access DB file in CF 9 in a Windows 2008 environment. When this >>>> happens, I >>>>>> also can't restart the CF ODBC Server. Restarting the box itself is >> the >>>>>> only solution. This isn't a heavily trafficked site. >>>>>> >>>>>> Anyone have any ideas what might be causing this and/or a work-around? >>>>>> >>>>>> Thanks! >>>>>> >>>>>> Ben > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
