double check on a make table

  • Thread starter Thread starter JRough
  • Start date Start date
J

JRough

I have a make table query and want to look at the records. Is it okay
if I open it? Will it open in datasheet view? The table is very
large I don't want to chance recreating that table and loosing my
current data.

tnx,
 
Open it in Design View (perfectly safe) and use the down arrow next to the
Query Type button to turn it into a Select Query.
Evi
 
Thanks, that is helpful. I noticed one thing it doesn't say the table
that it is creating. I didn't find this in the properties. The only
place I could find the new table name was in the SQL view. Is it
listed in the design view somewhere?

thanks again,
 
Thanks, that is helpful. I noticed one thing it doesn't say the table
that it is creating. I didn't find this in the properties. The only
place I could find the new table name was in the SQL view. Is it
listed in the design view somewhere?

thanks again,
Click to expand...

It's shown in SQL view as well as in query properties.
Look at the Destination Table property.

The query does not create the table until you click the Run (Bang)
tool button.
 
If you change the table back from a Select query to Make Table query, it
will remember your Table name - which you can then change if you wish.
Evi
 
Back
Top