Web Development

Ask something
Discussion Locked

Using Resync method in ADO MS VB

0 helpful
3 replies

by dfontahfru

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am developing in VB 6.0 with MSSQLSERVER as database. I wish to use the resync method and rollbacktrans method to restore the previuos state of the database. I have this runtime error : Run time error 21474672959 (80004005) Information on the column key is insufficient for the update or the refresh.
This is the command syntax:
ConnectionObject.Resync
How do I go about with this error?

3 replies

by andrew

When you initially retrieved the recordset, you may not have selected all the columns necessary to uniquely identify the records. Make sure you SELECT all the columns that comprise the PK.

Hope this helps.

This discussion is closed to new replies.