Error handling in a macro

M

Muggins

I have a macro that runs each hour and makes a table from a text file
on a remote unix server. Because of a timing issue, the macro
occasionally tries to make the table while the text file is being
updated, and the macro halts with an error, saying that it cannot find
the file.

My question is, is there a way of either testing for the existence of
the text file before making the table? and/or of adding some sort of
onerror action that will wait 30 seconds and try again?

thanks,

Larry
"Forget it, Jake. It's Chinatown."
 
J

Jörn Bosse

Am 07.06.2010 20:48, schrieb Muggins:
I have a macro that runs each hour and makes a table from a text file
on a remote unix server. Because of a timing issue, the macro
occasionally tries to make the table while the text file is being
updated, and the macro halts with an error, saying that it cannot find
the file.

My question is, is there a way of either testing for the existence of
the text file before making the table? and/or of adding some sort of
onerror action that will wait 30 seconds and try again?

thanks,

Larry
"Forget it, Jake. It's Chinatown."
Hello,

i don´t think so and that´s the reason why most of the developers aren´t
using macros....

Regard
Jörn
 
D

David W. Fenton

i donït think so and thatïs the reason why most of the developers
arenït using macros....

Depends on the version of Access. A2010 introduces what appears to
be robust error handling and flow control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top