Insufficient key column information for updating or refreshing.

2 Aug 2006 12:34 AM

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

2 Aug 2006 8:23 AM

gene kelley

On Wed, 02 Aug 2006 00:34:55 GMT, Kevin <Kevinp@nospam.cfl.rr.com> wrote:

>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