Error handling in a macro

Discussion in 'Access Macros' started by Muggins, Jun 7, 2010.

  1. Muggins

    Muggins Guest

    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?


    "Forget it, Jake. It's Chinatown."
    Muggins, Jun 7, 2010
    1. Advertisements

  2. Muggins

    Jörn Bosse Guest

    Am 07.06.2010 20:48, schrieb Muggins:

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

    Jörn Bosse, Jun 12, 2010
    1. Advertisements

  3. Depends on the version of Access. A2010 introduces what appears to
    be robust error handling and flow control.
    David W. Fenton, Jun 12, 2010
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.