number of SQL statements

[Tamir Khason]

SQL statement with the number of requests sepatater with ";" works fine in
MSSQL, however this does not work in Access. Is there any workaround of it?
Example:

INSERT INTO table (name) VALUES (value); INSERT INTO table1 (name1) VALUE
(value1); INSERT INTO table2 (name2) VALUES (value2)

 

[Van T. Dinh]

Write a Sub to execute the SQL statements one at a time.

 

[Tamir Khason]

In other words - It's impossible to do by SQL statement ???

 

[Van T. Dinh]

Not in JET SQL, AFAIK.