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 -~----------~----~----~----~------~----~------~--~---
