That would be nice .. :) !! The users for this app are a little more demanding. I used to use the old cfmx cfc code to create the access db, populate and then remove the datasource connection and before that the pre-mx hacks to create dsn's - I never really had a problem. I recently started using the cf 7 admin api and that's when the fun began. I might revert back to the cfmx 6 code.
I have attached the cfc I used to use - you can see why I wanted to move to the cleaner cf7 admin api calls. ----- Original Message ----- From: "Chad Renando" <[EMAIL PROTECTED]> To: <cfaussie@googlegroups.com> Sent: Monday, August 21, 2006 11:29 AM Subject: [cfaussie] Re: Access Lock File > > No, it's an issue w/ Access. Search around for ldb, Access, 'delete > locking file' and maybe cold fusion and you may find something. > > --> "The problem is releasing the lock file so users can download the > access db" > > I only used Access to upload and update my online SQL DB, not the > other way around. To go the other way, I ended up exporting to a text > file, having the user download the text file, replace the file on > their PC, that was a linked table in the client-side mdb. > > Chad > > > On 8/21/06, Rod Higgins <[EMAIL PROTECTED]> wrote: >> >> The problem is releasing the lock file so users can download the access >> db. >> Currently cf retains the lock file no matter what I try to do, while this >> lock file is present the OS can not delete, rename or remove either the >> lock >> file or the access db, so this stops any user gaining access to it. Kinda >> frustrating. At first I thought there was some sort of error in the >> insert >> code but I broke that down to a single query and still I have the same >> problems. I did a google search but can't dig up any issues with the cf >> admin api so I can only assume it's either my code or some issue with the >> OS? >> >> ----- Original Message ----- >> From: "Chad Renando" <[EMAIL PROTECTED]> >> To: <cfaussie@googlegroups.com> >> Sent: Monday, August 21, 2006 11:03 AM >> Subject: [cfaussie] Re: Access Lock File >> >> >> > >> > 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 -~----------~----~----~----~------~----~------~--~---
editdss.cfc
Description: Binary data
