Syntax for reference to another db

[merlynsdad]

I'm copying a table from another db to my db. I can't modify the other db. My code is

DoCmd.CopyObject , "tblName1", acTable, "path tblName"

I don't code Access that much and know I have a syntax problem referring to the path and other table name, since Access can't find it, but cannot remember or find a reference to what the proper syntax should be.



If the square peg won't fit in the round hole, sand off the corners.

 

[PHV]

I'd use the DoCmd.TransferDatabase method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[merlynsdad]

I only need to copy two tables out of a fairly large database. Why the TransferDatabase method as opposed to the CopyObject method?

If the square peg won't fit in the round hole, sand off the corners.

 

[PHV]

CopyObject is for copying an object from the current db to another db.
A starting point:

DoCmd.TransferDatabase acImport, "Microsoft Access", "\path\to\database.mdb", acTable, "tblName1", "tblName1"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886