What Scott said (the ideal method), or you need to write an deploy database script that completely stops the site in IIS, waits for the .lck file to disappear and then replaces the db and restarts the site (Im assuming youre on IIS). Even if the maintain database connections is off, the only safe and reliable way Ive found to deal with .lck files when replacing Access databases is to completely stop the site and wait for it to go away. You could remove them in Windows with Administrator permissions, but even that is iffy as sometimes you can end up totally locking up the directory.
Jon On Jul 3, 2014, at 2:15 PM, 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:358800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
