RE: Invoke PC Access program from an AS/400

[Chris Bipes <rpg@xxxxxxxxxxxxxxx>]

Client Access full version will support remote commands being accepted on
the pc from the as400.  Data queues are nice and VB can use the CA ape to
wait at a data queue for the results of your trigger program.  If the PC is
not communicating, the data queue will queue the data until the pc program
is started up again.  Does access provide api's?  The hardest part would be
the pc side. 

Good Luck

Christopher K. Bipes     mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst   mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.         http://www.cross-check.com
6119 State Farm Drive    Phone: 707 586-0551 x 1102
Rohnert Park CA  94928 Fax: 707 586-1884

*Note to Recruiters
Neither I, nor anyone that I know of, is interested in any new and/or
exciting positions. Please do not contact me.


-----Original Message-----
From: Denis Robitaille [mailto:DRobitaille@cascades.com]
Sent: Tuesday, November 16, 1999 10:45 AM
To: MIDRANGE-L@midrange.com
Subject: Invoke PC Access program from an AS/400


Hello all,

Here is my problem. I have a program on an AS/400 that is used to receive
raw material. Each time a reception is accepted, I must find a way to
transfer it to an access database located on an NT server. The transfer must
be close to real time because the material just received may be used in the
following minutes and the comsuption program is in access. I was planning to
do the following: 
1- Add a trigger to the reception file to trap any changes
2- add the information that need to be transferd to a work file (or data
queue, or whatever)
3- have the AS/400 evoke a command on one PC attach to the AS/400
4- The PCcommand would be an access program to download the work file, add
its information to the data base and then clear the work file

My problem is with step 3. What are the possible alternative? what do you
suggest?

Denis Robitaille
Directeur service technique
Cascades Inc
819 363 5187
fax 819 363 5177
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---