Re: Write in tables from access

I don't know the details, but we have a program developed by UPS that
updates shipping and inventory information, and another in the works that
will accept data entered via a telephone Voice Response Unit to accept
sales reports. Both of these use ODBC to access data in our System i
tables, and updates/writes to transaction tables.

The UPS program uses VB to update the data, and the telephone VRU uses
SQL. Each application writes to a transaction file, which in turn runs
through various edits (RPG programs) before being posted to the primary
data base files.

Steve

Steven Morrison
Fidelity Express





"Support Mwbrands" <support.mwbrands@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/03/2008 01:23 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
MIDRANGE-L@xxxxxxxxxxxx
cc

Subject
Write in tables from access






Hello,
How can I configure ODBC driver of iSeries to write in AS400 tables
directly
from Access.

I know it's possible to do it from iSeries Navigator. but how from Access?


Thanks,
Marco