A
Ant
Hi,
I'm trying to write some DDL and DML SQL code in Access 2000. I wrote a
CREATE TABLE command query and it worked fine and created the table. However
I then did the same again for another table and it says syntax error,
however it works when I make a seperate query and put the code in there, it
seems the problem is Access doesnt like having more than one command in a
query?
Can anyone help?
it seems a bit of a pain to have to make each command in a seperate query.
Thanks a lot for your help
I'm trying to write some DDL and DML SQL code in Access 2000. I wrote a
CREATE TABLE command query and it worked fine and created the table. However
I then did the same again for another table and it says syntax error,
however it works when I make a seperate query and put the code in there, it
seems the problem is Access doesnt like having more than one command in a
query?
Can anyone help?
it seems a bit of a pain to have to make each command in a seperate query.
Thanks a lot for your help