"Make Table Query" My table was deleted.

[Guest]

Does the table get deleted when a table is made from a query using the "make
table query" command ? It did it to me even though I think I was warned that
the table would be deleted. This doesn't seem right. I should be able to
make a table from a query without losing the origional table. Thanks for
anyone's help.

 

[Jeff Boyce]

Bob

It is rarely necessary to "make" a new table. If you can create a query
that returns rows that you want, you may not need to make a table of it.

And yes, if you use the same name for your "make table" query, the new query
overwrites the old table name. Isn't this exactly what happens if you try
to save a file with the same name as another? The new overwrites the old...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rick Brandt]

Does the table get deleted when a table is made from a query using
the "make table query" command ? It did it to me even though I think
I was warned that the table would be deleted. This doesn't seem
right. I should be able to make a table from a query without losing
the origional table. Thanks for anyone's help.

If by "original" you mean the source table that the query gets its records from
then no, that table is not deleted. If you already have a table with the same
name that the make-table query needs to make then yes, that table will be
deleted when you run the query.

 

[Dirk Goldgar]

Does the table get deleted when a table is made from a query using
the "make table query" command ? It did it to me even though I think
I was warned that the table would be deleted. This doesn't seem
right. I should be able to make a table from a query without losing
the origional table. Thanks for anyone's help.

Which table are you talking about? The one(s) your query is pulling
data from, or the one that it is creating to store the date in? A
make-table query has one or more source tables, and one output table.
When you run the query, the output table will be deleted, if it exists,
before the query recreates it and stores the selected records in it;
howver, the source table(s) shouldn't be affected in any way.