Don't panic!

Cry about...
MS-Windows Troubleshooting

Client Cursor: 39 - One of the modified columns has no source table defined

Symptom:

Visual Basic 6 using DAO returns the error:

Client Cursor: 39 - One of the modified columns has no source table defined

Possible Causes and Remedies:

  • Microsoft have a knowledge based article (Q177186) dealing with this error. The error case described there is when using a select to join result sets using a stored procedure.
  • Alternately I have encountered the problem when trying to insert records into a temporary SQL Server table from Visual Basic 6 using DAO. I believe this to be a bug in the Microsoft product, but do not know whether the problem is with VB, DAO, ODBC, SQL Server ODBC driver or SQL Server. My work around at the time was to substitute a non-temporary table for the temporary table and the problem went away.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.