SQL help needed please.

[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

 

[Roger Carlson]

Pain or not, that's how Access is. A query can only have one SQL statement
in it.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L