Micorosft Access 2007 -How To Run Multiple update queries at the same time

[ghufrang]

Hi,

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.

BUT

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?