>> 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
