ODBC Link

[Nick]

I am trying to update my database on the AS 400, but
everytime i'm getting this error:
ODBC - update on a linked table <table> failed. (Error
3157)

Do you guys have any idea how to fix this?

 

[Joe Fallon]

When you link to a table it should have a PK.
If not (or Access can't find it) then you should be prompted for a Unique
Record Identifier.
Select the combination of fields that uniquely identifies a record in that
table.

You can do it "after the fact" by using an query to create a fake index.

You can create a "Fake" index in Access that tells Access which columns make
a Unique record in the linked table. The index is only used by Access is
completely unknown to the Server.

The following example creates an index on an ODBC linked table. The table's
remote database is unaware of and unaffected by the new index. The following
example won't work if you simply paste it into Microsoft Access; you first
need to create an ODBC linked table called OrderDetailsODBC.

(CREATE INDEX Statement in Help has some examples)

CREATE UNIQUE INDEX OrderID ON OrderDetailsODBC (OrderID);