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:358799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
