double check on a make table

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

"JRough" wrote in message
...
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,

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,
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,

On Mon, 7 Apr 2008 11:10:16 -0700 (PDT), JRough wrote:

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,
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,

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.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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

"JRough" wrote in message
...
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,
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,