Is it possible to remotely start an import on machine "A" when a text file on machine "B" is modified? I can setup linked tables and run the following,...
qry_ManifestUpd ateAndInsert:
[CODE=sql]UPDATE tbl_tempManifes t AS tm LEFT JOIN tbl_Manifest AS m ON tm.tracking=m.t racking SET m.name = tm.name, m.store = tm.store, m.orderNum = tm.orderNum, m.tracking = tm.tracking;[/CODE]
but not sure how to setup a "trigger" if you will to let machine "A" know the text file has been updated. Open for suggestions, even more open for suggestions that would not require a linked table. I would like machine "B" to have control, machine "B" can be windows XP or linux.
Thanks!
qry_ManifestUpd ateAndInsert:
[CODE=sql]UPDATE tbl_tempManifes t AS tm LEFT JOIN tbl_Manifest AS m ON tm.tracking=m.t racking SET m.name = tm.name, m.store = tm.store, m.orderNum = tm.orderNum, m.tracking = tm.tracking;[/CODE]
but not sure how to setup a "trigger" if you will to let machine "A" know the text file has been updated. Open for suggestions, even more open for suggestions that would not require a linked table. I would like machine "B" to have control, machine "B" can be windows XP or linux.
Thanks!
Comment