Martin had helped me with this using DAO but it does not work with ADO
I am using ADO and a MS datagrid.
I can get my grid to display any table I want when ever I want. which is great.
Now here is my problem. How do I copy "table2" in "c:\db1.mdb" to "hello" in "c:\db1.mdb"?
I want table2 untouched so renaming the thing wont work.
Martin with the ADO referenced I get an error about invalid use of the new keyword when used as
Set Fld = New Field
(I had DAO reference on when I tried this, somehow ADO reference screw up you nice sub)
Can ADO do what I need?
thank you for your time and have a good day