Hi All,

If I have a database in Access (say myDB1.mdb) which has a table called tempResults and is filled with data, how can I place a copy of this table at run time in another database (Access) chosen by the user (at run time) (this could be a new db or one with tables already in it) and rename the table to whatever the user wants to call it?

EG.

DATABASE
- myDB1
_______________
Tables
- mytable1
- myTable2
- tempResults

Run-time -
User wants tempResults table saved to their database.
They say where their db is located eg. c:\progs\USERDB.mdb
They say what they want to call the tempResults table
eg. UsersResults
The program takes tempResults table, renames it UsersResults, and saves it in c:\progs\USERDB.mdb

(the tempResults table is still in its original state in myDB1 as well)


Hope you guys understand and can help

Cheers