Does the file have a unique key on it, I believe it is necessary in order to do updates through ODBC. Scott Mildenberger
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Insert using Micorosft Access 2000
Collapse
X
-
Insert using Micorosft Access 2000
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
-
Insert using Micorosft Access 2000
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.
Comment
Comment