Linked Tables and ODBC

[chrisjrice]

I have created an access database comprised of link tables connecting to my DB2 database on the Iseries. This has been working fine, but recently we upgraded to Iseries Access 5.2 with service pack, which changed all the ODBC drivers. I have since deleted all the link tables and re-linked them using the new Iseries ODBC driver. I have set the driver up as before given permission to read and write.

I am now getting the following error when i try to update the database, either through the form or the actual table:

ODBC — insert on a linked table <table> failed. (Error 3155)
underneath this error it reads:

[IBM][iSeries Access ODBC Driver][DB2 UDB] not valid for operation.

Can anyone help?

 

[Pat Hartman]

You would be better off taking this error to your DB2 DBA. The DB2 drivers are configurable so you may need to adjust some setting. Also make sure that the DB2 tables have primary keys defined. Jet requires that ODBC tables have unique primary keys to support updatablilty.