ODBC--Update on a Linked table ''tablename'' failed error 3155

  • I have a Access frontend and the tables are linked to a SQL server and when I try to update i Get that error

  • One of reasons could be record is not unique.

  • It even happens if I change the current record that is already in the table.  I use the RS. edit and RS.addnew then RS.Update.  I think it may have something to do with maybe a permission or a link perhaps

  • Did you upsize the Access DB to SQL? Does the table you're updating have a Primary Key? If not then the upsizing wizard will make it read-only...

     

  • Open your linked table in the Access db...check at the bottom where the record selectors are - make sure that the one on the far right (asterick) is not greyed out. This is why you need a primary key on your linked table so you can make changes to it.

  • TMSmith is right, but may not have given you enough information.

    To fix this, remove the link and reestablish it. Access will ask you to select a unique record identifier. Pick the field or fields that can identify this record as unique. The table will now be updateable.

     

    Shalom,

    Michael Lee


    Shalom!,

    Michael Lee

  • ... Unless you have no suitable field or fields for a primary key. In that case you will have to re-establish the local table (if you haven't deleted it yet it is called "Table Name - Local", just delete the Linked Table and rename the Local Table, otherwise delete the Linked Table and Export the table from SQL to Access). Now you have to create a unique ID field. You can use an Autonumber field. Set that as the key, then delete the table from SQL and run the Upsizing Wizard again just for that table.

    Sound like I've been there before?

     

Viewing 7 posts - 1 through 6 (of 6 total)

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