Re: Locks on Access files in CF 9
there are potentially many connections, like in any database system. so the fact that it's only one user is irrelevant - It is, because the principal argument of Access detractor is that it is not good in a multiuser environment. you still have concurrency issues. like with any database system. Access is a very economical and efficient solution for small or medium applications. In large applications the problem is not with Access, the problem is with the designer who chose the wrong solution. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
there are potentially many connections, like in any database system. Right. But other database systems can handle concurrency much better than Access can. That's why people generally recommend not to use Access in high-concurrency situations. so the fact that it's only one user is irrelevant - It is, because the principal argument of Access detractor is that it is not good in a multiuser environment. And that argument is fundamentally correct, because what most people mean when they talk about multiuser database environments is the ability to support multiple concurrent connections. The distinction between users and connections is meaningless if your concern is concurrency. And in these environments, the web application is typically acting as a multiplexer of sorts - it uses its own credentials to support multiple web users simultaneously. A web application is by its very nature a multiuser environment. you still have concurrency issues. like with any database system. No, not like with any database system. Most RDBMSs handle concurrency better than Access does. Access is a very economical and efficient solution for small or medium applications. It's no more economical than MySQL, the free version of MS SQL Server, or Postgres. It's not especially efficient for web applications due to file locking, lack of ability to remove unused space for deleted records, etc, etc. In large applications the problem is not with Access, the problem is with the designer who chose the wrong solution. If you're building a web application and you choose Access, you chose the wrong solution. It may not be the end of the world, but it's not the best choice for any web application. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Locks on Access files in CF 9
Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Try running a bad query against the datasource (whip up a CFM file call LockKill.cfm and stuff a CFQUERY in it - run in browser SELECT gum FROM Pack_of_Gum should do the trick ;-) This was the old school way to get Access to let go Run the query and then refresh the folder with your DB file in in and the lock file should go way If not...try a few more times as sometimes it would take a couple of attempts HTH Cheers *Bryan Stevenson*B.Comm. President CEO Electric Edge Systems Group Inc. - makers of FACTS^(TM) phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com mailto:br...@electricedgesystems.com web: www.electricedgesystems.com http://www.electricedgesystems.com and www.fisheryfacts.com http://www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
...and now you are That Guy Phillip ;-) I agree wholeheartedly, but thought I'd try and provide help for the actual issue that is in Ben's face at the moment. Cheers *Bryan Stevenson*B.Comm. President CEO Electric Edge Systems Group Inc. - makers of FACTS^(TM) phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com mailto:br...@electricedgesystems.com web: www.electricedgesystems.com http://www.electricedgesystems.com and www.fisheryfacts.com http://www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On 14-07-03 10:59 AM, Phillip Vector wrote: Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben On Jul 3, 2014, at 10:59 AM, Phillip Vector vec...@mostdeadlygame.com wrote: Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358795 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Oh. That's clever. Even devious. Will try it. Thanks! Ben On Jul 3, 2014, at 11:04 AM, Bryan Stevenson br...@electricedgesystems.com wrote: Try running a bad query against the datasource (whip up a CFM file call LockKill.cfm and stuff a CFQUERY in it - run in browser SELECT gum FROM Pack_of_Gum should do the trick ;-) This was the old school way to get Access to let go Run the query and then refresh the folder with your DB file in in and the lock file should go way If not...try a few more times as sometimes it would take a couple of attempts HTH Cheers *Bryan Stevenson*B.Comm. President CEO Electric Edge Systems Group Inc. - makers of FACTS^(TM) phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com mailto:br...@electricedgesystems.com web: www.electricedgesystems.com http://www.electricedgesystems.com and www.fisheryfacts.com http://www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
On 14-07-03 11:06 AM, Ben wrote: Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben Ugh...that is horrible! ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
You *could* put a system together where the client, or you uploads the access database, the system programatically creates a datasource on the fly transfers any data changes to the real database, kills the datasource and deletes the access db, the client can do what he wants and you don't have to deal with access lock file issues. On Thu, Jul 3, 2014 at 2:06 PM, Ben b...@webworldinc.com wrote: Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben On Jul 3, 2014, at 10:59 AM, Phillip Vector vec...@mostdeadlygame.com wrote: Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Yep. So is the site. So 1995. But they are rewriting it in one of the newer languages-du-jour which will solve ALL their problems. :) Ben On Jul 3, 2014, at 11:10 AM, Bryan Stevenson br...@electricedgesystems.com wrote: On 14-07-03 11:06 AM, Ben wrote: Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben Ugh...that is horrible! ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
What Scott said (the ideal method), or you need to write an deploy database script that completely stops the site in IIS, waits for the .lck file to disappear and then replaces the db and restarts the site (Im assuming youre on IIS). Even if the maintain database connections is off, the only safe and reliable way Ive found to deal with .lck files when replacing Access databases is to completely stop the site and wait for it to go away. You could remove them in Windows with Administrator permissions, but even that is iffy as sometimes you can end up totally locking up the directory. Jon On Jul 3, 2014, at 2:15 PM, Scott Stewart webmas...@sstwebworks.com wrote: You *could* put a system together where the client, or you uploads the access database, the system programatically creates a datasource on the fly transfers any data changes to the real database, kills the datasource and deletes the access db, the client can do what he wants and you don't have to deal with access lock file issues. On Thu, Jul 3, 2014 at 2:06 PM, Ben b...@webworldinc.com wrote: Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben On Jul 3, 2014, at 10:59 AM, Phillip Vector vec...@mostdeadlygame.com wrote: Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Interesting. Probably more work than I want to out in unless needed. Anyone know why the lck file gets sticky? CF issue? ODBC issue in Windows? Just curious Ben On Jul 3, 2014, at 11:15 AM, Scott Stewart webmas...@sstwebworks.com wrote: You *could* put a system together where the client, or you uploads the access database, the system programatically creates a datasource on the fly transfers any data changes to the real database, kills the datasource and deletes the access db, the client can do what he wants and you don't have to deal with access lock file issues. On Thu, Jul 3, 2014 at 2:06 PM, Ben b...@webworldinc.com wrote: Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben On Jul 3, 2014, at 10:59 AM, Phillip Vector vec...@mostdeadlygame.com wrote: Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Locks on Access files in CF 9
It's Access. Need we say more? (hehe) Actually I believe it has something to do with a combination of ODBC and Windows and the JET drivers. Other ODBC connections don't seem to lock that way but if you look really hard with google you can find a tool that will list the locks and what is holding them and another tool (in the same package) that lets you kill them, however the caveat I read years ago was that after doing that you immediately needed to run a clean and repair on the Access DB. Steven Durette -Original Message- From: Ben [mailto:b...@webworldinc.com] Sent: Thursday, July 03, 2014 2:32 PM To: cf-talk Subject: Re: Locks on Access files in CF 9 Interesting. Probably more work than I want to out in unless needed. Anyone know why the lck file gets sticky? CF issue? ODBC issue in Windows? Just curious Ben On Jul 3, 2014, at 11:15 AM, Scott Stewart webmas...@sstwebworks.com wrote: You *could* put a system together where the client, or you uploads the access database, the system programatically creates a datasource on the fly transfers any data changes to the real database, kills the datasource and deletes the access db, the client can do what he wants and you don't have to deal with access lock file issues. On Thu, Jul 3, 2014 at 2:06 PM, Ben b...@webworldinc.com wrote: Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben On Jul 3, 2014, at 10:59 AM, Phillip Vector vec...@mostdeadlygame.com wrote: Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Access was never designed to be a multiuser DB. The .lck file just grows as more connections are made. It will eventually kill the box it it's left alone long enough On Thu, Jul 3, 2014 at 2:32 PM, Ben b...@webworldinc.com wrote: Interesting. Probably more work than I want to out in unless needed. Anyone know why the lck file gets sticky? CF issue? ODBC issue in Windows? Just curious Ben On Jul 3, 2014, at 11:15 AM, Scott Stewart webmas...@sstwebworks.com wrote: You *could* put a system together where the client, or you uploads the access database, the system programatically creates a datasource on the fly transfers any data changes to the real database, kills the datasource and deletes the access db, the client can do what he wants and you don't have to deal with access lock file issues. On Thu, Jul 3, 2014 at 2:06 PM, Ben b...@webworldinc.com wrote: Yeah, you're preaching to the choir on that one. :) This client tweaks their copy of the DB with local apps then uploads it to the server. Ben On Jul 3, 2014, at 10:59 AM, Phillip Vector vec...@mostdeadlygame.com wrote: Not to be That Guy... But transfer the data to an actual database and use that? On Thu, Jul 3, 2014 at 10:53 AM, Ben b...@webworldinc.com wrote: Sorry, didn't mention that. It is off. Ben On Jul 3, 2014, at 10:51 AM, Scott Stewart webmas...@sstwebworks.com wrote: Turn off maintain connections in the data source properties. On Jul 3, 2014 1:49 PM, Ben b...@webworldinc.com wrote: Hi I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. This isn't a heavily trafficked site. Anyone have any ideas what might be causing this and/or a work-around? Thanks! Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
But transfer the data to an actual database I was expecting this clever answer! ;-) Access has a bad reputation in a LAN multiuser APPLICATION. But it is only when the application is also an Access application. All requests cause many accesses to the disk, both for code and for data, which causes a bottleneck. In a coldFusion application, the application is NOT stored in the same file as the database, and there is only ONE user: Coldfusion is the user. I've noticed that since I have my database installed on Windows 7, locks are even more capricious than before if you open the database in the same time you run a CF application, and this does not come from Access. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
bottom line: Access sucks unless your inventorying a CD collection. On Thu, Jul 3, 2014 at 2:49 PM, wrote: But transfer the data to an actual database I was expecting this clever answer! ;-) Access has a bad reputation in a LAN multiuser APPLICATION. But it is only when the application is also an Access application. All requests cause many accesses to the disk, both for code and for data, which causes a bottleneck. In a coldFusion application, the application is NOT stored in the same file as the database, and there is only ONE user: Coldfusion is the user. I've noticed that since I have my database installed on Windows 7, locks are even more capricious than before if you open the database in the same time you run a CF application, and this does not come from Access. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Access is actually not bad as a user interface. When I have clients who are using it, I migrate the data to production level database then use the Access link table function to allow them to continue to use the interface without needing to recreate it in another tool, or retrain them for a different interface. The works especially well for existing projects with lots of reports. On Thu, Jul 3, 2014 at 2:53 PM, Scott Stewart webmas...@sstwebworks.com wrote: bottom line: Access sucks unless your inventorying a CD collection. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
You like have a hung request which is maintaining a connection to the db. Use the server monitor to check. Only solution for this is to restart cf. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 3 Jul 2014 20:06, Maureen mamamaur...@gmail.com wrote: Access is actually not bad as a user interface. When I have clients who are using it, I migrate the data to production level database then use the Access link table function to allow them to continue to use the interface without needing to recreate it in another tool, or retrain them for a different interface. The works especially well for existing projects with lots of reports. On Thu, Jul 3, 2014 at 2:53 PM, Scott Stewart webmas...@sstwebworks.com wrote: bottom line: Access sucks unless your inventorying a CD collection. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Locks on Access files in CF 9
I'm seeing an odd issue where a .lck file doesn't go away at times on an Access DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't restart the CF ODBC Server. Restarting the box itself is the only solution. The way we use to release a lock on an access DB file was to run a bad query against the data source. Add an extra field name not in the table to a select statement. This lets the Jet driver release the file until a new query is initiated. This isn't a heavily trafficked site. Good thing or you would never be able to release the lock. I am sure it goes without saying, but yet I am saying it, but Access is not the best solution for multi-user environments. However, I understand that the best solutions may not always be and option. Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Thanks, guys! I knew I would get the full picture here and wasn't disappointed. Best wishes and Hope you have a great 4th of July! --Ben -- Ben Conner b...@webworldinc.com Web World, Inc. 888-206-6486 or PO Box 1122 480-704-2000 Queen Creek, AZ 85142 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
Have a good 4th! ...from Canada ;-) *Bryan Stevenson*B.Comm. President CEO Electric Edge Systems Group Inc. - makers of FACTS^(TM) phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com mailto:br...@electricedgesystems.com web: www.electricedgesystems.com http://www.electricedgesystems.com and www.fisheryfacts.com http://www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On 14-07-03 02:58 PM, Ben Conner wrote: Thanks, guys! I knew I would get the full picture here and wasn't disappointed. Best wishes and Hope you have a great 4th of July! --Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Locks on Access files in CF 9
But transfer the data to an actual database I was expecting this clever answer! ;-) Access has a bad reputation in a LAN multiuser APPLICATION. But it is only when the application is also an Access application. All requests cause many accesses to the disk, both for code and for data, which causes a bottleneck. In a coldFusion application, the application is NOT stored in the same file as the database, and there is only ONE user: Coldfusion is the user. While there is only one user account, there are potentially many connections, so the fact that it's only one user is irrelevant - you still have concurrency issues. You also have other problems, such as the inability of Access to perform routine table maintenance while the database is being used by CF. For example, the space originally allocated for records isn't reclaimed properly when the records are deleted. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
