Using Microsoft ACCESS to load data into the AS/400.

[David Abramowitz]

Check the configuration of your ODBC driver. It may be read only. Dave

[Guest.Visitor]

Using Microsoft ACCESS to load data into the AS/400.

I am working with Microsoft ACCESS and the OS/400. Our current process of loading data into the OS/400 has too many steps. I am trying to use MS ACCESS to reduce the number of steps. Currently I am able to read from the OS/400 into ACCESS, but I cannot write to the OS/400. My test link is K944TST, QGPL data file WPCIMP_TST. I have read through various articles and books with no help. Any and all help on linking, (connecting), to the OS/400 to allow reading and writing would be greatly appreciated. Frank

[Guest.Visitor]

Using Microsoft ACCESS to load data into the AS/400.

I have check the the driver settings and they are set for both read/write. Is there some sample code I can review? Frank