Results 1 to 2 of 2

Thread: Macro problem

  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Unanswered: Macro problem

    I'm using Access 2000.

    I have a macro which I use to update a database. It contains other macro's which execute, the first one being a make table query. Echo is turned off.

    When I run the update macro the make table query times out and halts the macro execution. If I run each query individually, by double clicking on the query, they run without any problems. It's only when I try to use a macro that the time out occurs.

    Any ideas or thoughts on this would be appreciated.

    drh
    Last edited by drh; 07-07-06 at 13:11.

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Remove the line that turns echo off - it is probably waiting for a user input and since echo is off, you don't see it.

    tc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •