Want to see the new table in the list 1

[jslmvl]

Hi,

Using VBA code in a .mdb, I got a new table (Table2) from Table1:
cn.Execute "Select * Into Table2 From Table1"
It was working fine. However, I could not find the new table in "All Access Objects" list, until I close the Access ang reopen it.

What I can do to see the new table in the list without close-open?

 

[lameid]

Switch from the tables tab to another like queries, forms or reports and swicht back... At least that is what I do in Access 2003.

You might get lucky with F5 or F9 using a later version, I don't know.

 

[jslmvl]

Yes, F5 works for me. Thanks a lot.