Copy Object

[Guest]

I am using the CopyObject method to copy tables from one mdb database to a
new one on a different machine on the same network After execution, the new
database contains Links To the tables in the first database. I want to
actually import the data into the new database. How can I do that?
Thanks.

 

[Marshall Barton]

I am using the CopyObject method to copy tables from one mdb database to a
new one on a different machine on the same network After execution, the new
database contains Links To the tables in the first database. I want to
actually import the data into the new database.

CopyObject (and TransferDatabase) use the current database.
When you have a front end - back end configuration, the fron
end only has a link so that is what's copied.

Off the top of my head I think you need to use a Make Table
query:

SELECT * INTO newtable IN "path to new mdb"
FROM oldtable IN "path to backend mdb"

For a Jet (Access) back end, you can get the path to the
back end mdb from the link in the front end:

strBEPath = Mid(CurrentDb.TableDefs!oldtable.Connect, 11)

 

[Guest]

Thanks Marsh, that works beautifully