table already exists

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

Guest

I cant 'run' a data definition query where I created a table in SQL, because
i get the error msg " table "tablename' already exists. Any ideas? The tables
i have coded appear under the queries menu but not under the tables menu in
the database window. I am using access 2000.
 
You can't have a saved view as the same name as a table.

(I don't think you can do this in sql server either!).

So, for all intensive purposes, a select query that is saved in ms-access is
the SAME idea as a view.

The only reason why we don't call them views in ms-access is that saved
queries in ms-access can also be update queries, and delete quires and other
types of quires.

Since the whole idea of a view is to look like a table (to the end user...or
even to your program code), then there is no way to distinguish between a
query with the same name as a table....
 
Back
Top