creating SQL tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
accessnewb said:
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.
Click to expand...

Sorry, I can't quite parse this sentence:
They appear on the
database window under 'Queries' but on under the 'Tables' menu.
Click to expand...

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?
 
Back
Top