locked
2501 The OpenQuery action was canceled. RRS feed

  • Question

  • hi
    i am getting the 2501 The OpenQuery action was canceled. when i run my excel macro to run a query which will update the access table convert them to excell and save them in a particular folder.

    the code was working unlit few day but for past couple of day i am getting this issue only in few system (the server and my system) few other users are not having this issue that they could successfully run the macro and the process is complete in their machine.

    Please help me in resolvin the issue

    Friday, November 1, 2013 8:24 AM

Answers

  • hi
    i am getting the 2501 The OpenQuery action was canceled. when i run my excel macro to run a query which will update the access table convert them to excell and save them in a particular folder.

    the code was working unlit few day but for past couple of day i am getting this issue only in few system (the server and my system) few other users are not having this issue that they could successfully run the macro and the process is complete in their machine.

    Please help me in resolvin the issue

    Hi sridevipc,

    It could be that you have some timing problems.
    Include one (or some) DoEvent statements (see Help for further details) on crucial places in your code, and see if this helps.

    Imb.

    • Marked as answer by George Hua Monday, November 11, 2013 3:58 PM
    Friday, November 1, 2013 1:04 PM