creating SQL tables

[accessnewb]

I created tables with the data definition option in SQL and established
primary keys and foreign keys. They appear on the database window under
'Queries' but on under the 'Tables' menu. I went to the "Queries' menu in the
toolbar and clicked 'Run" but an error message : "Table <tablename> already
exists". I dont have any other tables with the same name. And each time I
'Run" every table displays that same message. I'm not familiar with using SQL
in Access, could someone please help? Im using Office XP Pro.

 

[Dirk Goldgar]

I created tables with the data definition option in SQL and
established primary keys and foreign keys. They appear on the
database window under 'Queries' but on under the 'Tables' menu. I
went to the "Queries' menu in the toolbar and clicked 'Run" but an
error message : "Table <tablename> already exists". I dont have any
other tables with the same name. And each time I 'Run" every table
displays that same message. I'm not familiar with using SQL in
Access, could someone please help? Im using Office XP Pro.

Sorry, I can't quite parse this sentence:

They appear on the
database window under 'Queries' but on under the 'Tables' menu.

Would you mind rewriting that?

Are you working in an MDB file or in an ADP? Can you post the SQL of
one of the make-table queries that (I gather) you ran?