Access was never designed to be a multiuser DB. The .lck file just grows as more connections are made. It will eventually kill the box it it's left alone long enough
On Thu, Jul 3, 2014 at 2:32 PM, Ben <b...@webworldinc.com> wrote: > > 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:358803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
