Copy Objects between remote databases

[AlPhilps]

I want to copy objects from Remote Database1 to Remote Database2, whilst the code is resting in Database3.

I realise that the CopyObject function only permits me to copy from a Source database to a remote specified database, not from remote to remote.

Any ideas? Or am i Stuffed?

Ta

Al

 

[dpimental]

One alternative is to copy from 1 to 3 and then from 3 to 2.

David David Pimental
(US, Oh)
dpimental@checkfree.com

 

[AlPhilps]

*One alternative is to copy from 1 to 3 and then from 3 to 2.*

Hmmm. If I go into #1 tho, I might as well copy straight to #2?

 

[GGleason]

Try the following:
[tt]
Dim ObjFrom As New Access.Application, ObjTo As New Access.Application

ObjFrom.OpenCurrentDatabase ("C:\From.mdb&quot
ObjTpenCurrentDatabase ("C:\To.mdb&quot
ObjFrom.DoCmd.CopyObject "C:\To.mdb", "tblA", acTable, "tblA"
ObjTo.CurrentDb.Close
ObjTo.CloseCurrentDatabase
Set ObjTo = Nothing
ObjFrom.CurrentDb.Close
ObjFrom.CloseCurrentDatabase
ObjFrom.Quit acQuitSaveNone
Set ObjFrom = Nothing
[/tt]
hth,
GGleason

 

[AlPhilps]

Ah, mebbe I should have pointed out we're still using Access v2 here?
That rules out OpenCurrentDatabase I think?

Ta

Al