[AccessD] Access2000 - DoCmd.TransferDatabase

<<<
> I'm trying to determine how to let Access know the MDB
> to use for the other side of the operation.
>>>
Dave,

You've to use your "D" as a library database setting ref to it from "C" or
if your "D" is a FE database then you've to use Automation, i.e. start
another instance of MS Access from within Access, open "C" in it and use
TransferDatabase in it:

set app = CreateObject("Access.Application")
app.opencurrendatabase ("c",...

app.docmdtransferdatabase ...
...

HTH,
Shamil

----- Original Message -----
From: "dave sharpe" <davesharpe2 at cox.net>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, February 19, 2003 2:26 AM
Subject: [AccessD] Access2000 - DoCmd.TransferDatabase


> Access2000
>
> I'm trying to consolidate two MDBs ( "A" & "B" ),
> into a third ("C") which I create via code. I
> have all of my code in a third ("D"). I've
> extablished four workspaces.
>
> I'm trying to use DAO 3.6 and am using
> DoCmd.TransferDatabase [transfertype],
> databasetype,
> databasename[,
> objecttype],
> source,
> destination[,
> structureonly][,
> saveloginid]
>
> This has on one place to specify
> an object MDB (databasename) as
> the "Import from" or "Export to"
> database. I'm trying to determine
> how to let Access know the MDB
> to use for the other side of the
> operation.
>
> Thank you in advance for any
> guidance that you might be
> able to provide.
>
> Dave
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com