Insert using Micorosft Access 2000

[S.Mildenberger]

Does the file have a unique key on it, I believe it is necessary in order to do updates through ODBC. Scott Mildenberger

[Guest.Visitor]

Hi, I have linked my AS/400 File in Access. When I am trying to enter the data in the file, I got the following error ODBC--insert on a linked table MyTable failed. [IBM][Client Access Express ODBC Driver 32 bit][DB2/400 SQL]SQL7008 MyFile not valid of operation (#-7008) My ODBC-DSN have Read/Write Option Selected. I am using Client Access V5.1. Thanks Shafiq

[rv_ooty@hotmail.com]

First check if your physical file is journalled. Otherwise you will get the same error and insert or update will not work. if you have CAE V4R4 and above means CAE supports ADO2.0 standards. otherwise only ADO1.5 standard. So no insert or update on AS400 from windows - forget it or ask IBM.