Insufficient key column information for updating or refreshing.

[Kevin]

I'm using a "View" in SQL2000 to print records. My query on the View
worked fine in VB6. I'm using the same ADODB in my VB2005 app (not
ADO.NET) and I'm getting this error. There's 197 records in my query
and on the 27th record it bombs out. Nothing special about that
record. I've tried adding Primary Keys from both tables (the View
consist of records from two tables) and it seems nothing works. The
code is virtually the same as my VB6 project which works fine.

This is problem number 9,569 I've had trying to convert to VB2005. I'm
really wondering if it's worth it....

[gene kelley]

On Wed, 02 Aug 2006 00:34:55 GMT, Kevin <Ke****@nospam.cfl.rr.comwrote:

>I'm using a "View" in SQL2000 to print records. My query on the View
worked fine in VB6. I'm using the same ADODB in my VB2005 app (not
ADO.NET) and I'm getting this error. There's 197 records in my query
and on the 27th record it bombs out. Nothing special about that
record. I've tried adding Primary Keys from both tables (the View
consist of records from two tables) and it seems nothing works. The
code is virtually the same as my VB6 project which works fine.

This is problem number 9,569 I've had trying to convert to VB2005. I'm
really wondering if it's worth it....

FWIW, trying to "convet" a major VB6 app is generally an exercise in futility.
You should consider rewriting the app in NET and using ADO. It's a great leaning experience.
Gene