Visual Basic Run-Time error

I received a run-time when runing a visual basic program which updating SQL database from Access database.

The error message is an follow:

Run-Time error '-2147467259(80004005)'

Insufficient or incorrect key column information, too many rows affected by update.

Many Thanks

Felicia
feliciaAsked:
Who is Participating?
 
KurvyCommented:
Alternatively the key column in sql server could be set to not null and you are trying to pass it null data or the datatype is wrong or the key is set to be unique.  Have you checked that the allow bulk updates box is checked in SQLserver?

Kurvy
0
 
LorenGCommented:
Felicia,

My guess is that the sql table you linked in Access does not have a primary key.  If this is the problem, you can fix it by relinking the table in access and making sure you have selected all the primary keys when prompted.

- Loren
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.