I don;t believe that will work, given that you can not manually delete it via FTP. The Access locking file is a pain.... if you ignore the fact that Access was not designed or recommended to be web enabled. That said, I have had success with it when using it in similar applications to Rod's, as a temporary transfer device. You just have to watch the file size and Access' tendency to blow them out when you don't compress.
Chad On 8/21/06, Scott Thornton <[EMAIL PROTECTED]> wrote: > > could you program a CFFILE delete of the lock file immedialty after the > population of the database? > > >>> [EMAIL PROTECTED] 21/08/2006 10:55 am >>> > > Hi Chad, > > Im using access to dump very small sections of data from a much larger SQL > database so users can download the access db and run ad hoc reports from it. > I am not using access as a primary datasource. And no DTS is not an option - > mostly due to security / access concerns to the primary datasource and > complexity of the parameters passed into the extraction process. > > Rgds > Rod > > ----- Original Message ----- > From: "Chad Renando" <[EMAIL PROTECTED]> > To: <cfaussie@googlegroups.com> > Sent: Monday, August 21, 2006 10:47 AM > Subject: [cfaussie] Re: Access Lock File > > > > > > I ran into it, but had to design my app in a manner that didn't > > require DB creation stuff in an Access file. Main reason I move to > > SQL. > > > > Chad > > > > On 8/21/06, Rod Higgins <[EMAIL PROTECTED]> wrote: > >> > >> Hi, > >> > >> Currently I am having major issues with creating an MS Access with > >> Unicode > >> datasource via the CF admin api. The datasource is created I pump some > >> data > >> into the access db but then it seems to create a lock file that will not > >> release even after I remove the datasource via the same api. The usual > >> malformed query workaround doesn't seem to release the lock file nor any > >> other workaround I have tried. Has anyone come across this and have a > >> solution that works to release the lock? > >> > >> CF7 Ent on Windows 2003. > >> > >> TIA > >> Rod > >> > > >> > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---