[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

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
0
felicia
Asked:
felicia
1 Solution
 
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
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now