[cfaussie] Re: Access Lock File
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 -~--~~~~--~~--~--~---
[cfaussie] Access Lock File
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 -~--~~~~--~~--~--~---
[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 -~--~~~~--~~--~--~---
[cfaussie] Re: Access Lock File
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 -~--~~~~--~~--~--~---
[cfaussie] Re: Access Lock File
Does the old: cfset CFUSION_DBCONNECTIONS_FLUSH() Still work? Haven’t tried it myself for a while though -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rod Higgins Sent: Monday, 21 August 2006 11:13 AM 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 -~--~~~~--~~--~--~---
[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 -~--~~~~--~~--~--~---
[cfaussie] Re: Access Lock File
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