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