So where is the problem? Is it in dumping to the Access DB or in the download?
If it is in dumping to the Access DB, can you not just run a delete and insert query to update with the latest data? How many users? Another solution may be to dump to a comma delimited file which the user downloads and run an automated import using Access on the client side. Chad On 8/21/06, Rod Higgins <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
