A make table stump?

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

Guest

I have created a "Make table" Query and saved it, but when I go to run the
query, Access instead of saying it wants to delete the table before running
it say it wants to delete the QUERY? and it does then it gives me a an error
that there is not data to run, any clue?

I have tried to write it several time and even set it to a selet query just
to make sure I wasn't going nuts, worked fine??
JB
 
Interesting. You didn't name the table the same as the query by chance?
Actually I don't think that you can.

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 
I have created a "Make table" Query and saved it, but when I go to run the
query, Access instead of saying it wants to delete the table before running
it say it wants to delete the QUERY? and it does then it gives me a an error
that there is not data to run, any clue?

I have tried to write it several time and even set it to a selet query just
to make sure I wasn't going nuts, worked fine??
JB
Click to expand...

One question:

WHY do you want to run a MakeTable query?

In practice they are *very* rarely needed. If you want to see data in a Form,
or a Report, or an export - you can do so from a Select Query without the
overhead of creating a new table, updating all the systems tables, creating
automatic indexes on the new table, ...

Consider whether this table *even needs to exist at all*.

John W. Vinson [MVP]
 
Back
Top