Expert: Clint Willard - 1/29/2009

Question
Hello Clint --

A CF application built by someone else points to the same SQL Server db as my ACCESS VBA application. When the CF app is running I can't edit records using the ACCESS app, either through a form or directly via the table.

Could this be a connection problem?  If so, can you tell me what to look for in the CF code to see why CF is locking the records?  If CF can simply use a default connection string, are there parameters to set in a fully-formed connection string to solve the problem?

If not a connection problem do you have any ideas about the locking problem?

Thank you for any help.

Larry Mehl


Answer
If I read right: Accessing the data from the SQL server, CF works and ACCESS doesn't, unless CF is stopped then ACCESS works again. Doesn't make sense if all the servers and apps are separate, which they are. I'm sticky with my ODBC and JDBC knowledge but any RDBS should be accessible by multiple applications, each locking the connection as needed while taking turns. I'm not aware of CF doing any total locking except during a query. If the apps were doing a query at the same exact time then I could see this happening maybe. Frankly, as long as the CF app can access the SQL server then it isn't a CF problem. Try asking an Access group for more help or possibly an MSSQL DBA group. And even if it turns out to be a CF problem then it sounds more like a CF bug than any CF coding or configuration setting. As for troubleshooting, if CF isn't logging errors at that time then you can't troubleshoot it from CF any ways; can't fix what's not broken.