I have an access mdb with ODBC table links to a SQL Server database (MSDE).
I can update the data in most of the tables except some where I get the message
ODBC--update on a linked table TABLENAME failed.
Now I understand that the SQL server table must have a unique index which it does.
It has a primary key indes which is also unique. Is that sufficient??
Why is this happening?
access project is the cleanest way but if you can manipulate data using your present method on other data then connectivity is not the issue - permissions or updating methods are the issue - at a more drill down level - perhaps the tables are not really as identical as you may think.
Create a new table that is identical in structure with the table that is fine.
Can you add records at this point?
Look at the structure - what is different from the problematic table?
Are you passing parameters? Are the indecies the same data types?
Take the problematic table and remove one field at a time - divide and conquer - do you have permissions to create tables on the SQL server?