Post reply

Error "Key column information is insufficent or incorrect. Too many rows were affected by update."

  • December 7, 2004 at 10:23 am

    #66649

    I am using a Sequel Server backend with a Access Project front end. 

    I have a Sequel Server table with a primary key and one foreign key relationship.  "Enforce relationship for replication", "Enforce relationship for INSERTS and UPDATEs", and "Cascade Update Related Fields" are selected for the relationship.

    The Access Project form is a query of the primary table data only.  When the primary key information is updated, the following error message displays:  "Key column information is insufficent or incorrect.  Too many rows were affected by update".

    I am the only one accessing the database, and the form.  This error message only appears when the primary field is updated.  Any suggestions?

  • December 8, 2004 at 3:56 am

    #533004

    Hi

    This error normally means Access can't work out how to identify and pass back to SQL-Server which columns to update because it doesn't have enough information.

    When you linked the SQL table to MS Access it should have asked you to specify which columns in the table to use as key columns (I can't remember exactly how this is phrased) and you're presented with a list of all the columns in the table, where you can select which column (or combination of columns) uniquely identify each row.

    Try deleting the link to the table and relinking it so you can set this.

    Hope that helps

    Sam

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply