Rod, no one has mentioned this: have you gone into the "show advanced settings" button of the datasource definition (in the CF Admin) to tell it "turn off" the "maintain connections" option? That's what's really causing the lock (as would any app that opened and kept open the .mdb file). Of course, as others have proposed, getting off of Access should be the next step (I realize that may be out of your hands).
One other thought, if this doesn't work, is to ask whether your datasource is defined in the CFMX admin as being an "ODBC socket" or a "Microsoft Access" type. The former means you point at an existing ODBC DSN, where the latter uses a built-in connection CFMX offers using DataDirect. Whichever you have, try the other. Shouldn't have any negative impact on how the code works (but of course you should thoroughly test before relying on the change in production). Let us know how it goes. /charlie http://www.carehart.org/blog/ -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Sunday, August 20, 2006 9:13 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Access Lock File 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 -~----------~----~----~----~------~----~------~--~---
