Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Unanswered: How To Run Multiple update queries at the same time

    Whenever i try to run multiple update queries at the same time , i will encounter this error "Characters Found After End Of SQL Statement".

    update Table1
    set ColumnA="A"
    Where ColumnB="B";

    update Table1
    set ColumnA="C"
    Where ColumnB="D";

    Do any one has idea on how to overcome this?
    I find online and some suggest that make a macro and run the queries in the macro.
    I find out that the queries that i can put into macro does not support multiple update queries at the same time.

    Does anyone has idea on this?


  2. #2
    Join Date
    Apr 2005
    Zagreb - Croatia
    Look at "DemoUpdateQueryA2002.mdb" (attachment, zip).
    Table1, queries, Form1.
    Open Form1 and try.
    Before take a copy of your table.
    Attached Files Attached Files

Posting Permissions

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