Example of handshaking in access

  • Thread starter Thread starter Tim Schiermeyer
  • Start date Start date
T

Tim Schiermeyer

I have just run into a problem with Access freezes up because I am running a
batch file that interfaces with a program to produce a text that is linked
to within access. The order of operation is to delete the link table,
produce the text file, and then relink. The reason I delete the linked table
is I figured it is easier then deleting all the data and updating that way.
The reason I am deleting the table every time is just in case the data that
access links to is deleted or moved. I know I could be more sophisticated on
my approach, but this way is bulletproof as I see it. Anyways back to the
problem, I need to know if there is a away in Access to do some handshaking
with other programs as to know when a process stops and can move onto the
next process.
 
Hi Tim,

1) Use the Shell-and-wait routine at
http://www.mvps.org/access/api/api0004.htm

2) You don't need to delete the linked table. Just make sure that all
objects (queries, recordsets, etc.) that refer to it are closed; then
you can delete and re-create the textfile to which it links.

I have just run into a problem with Access freezes up because I am running a
batch file that interfaces with a program to produce a text that is linked
to within access. The order of operation is to delete the link table,
produce the text file, and then relink. The reason I delete the linked table
is I figured it is easier then deleting all the data and updating that way.
The reason I am deleting the table every time is just in case the data that
access links to is deleted or moved. I know I could be more sophisticated on
my approach, but this way is bulletproof as I see it. Anyways back to the
problem, I need to know if there is a away in Access to do some handshaking
with other programs as to know when a process stops and can move onto the
next process.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top