Copying to Access from Access

[IanW]

Hi,

Can anyone point me in the right direction please. I am trying to copy objects (forms, reports, queries, etc) from the current database into another (closed) database using VBA (Access.Application object). Any pointers or advice will be gratefully received

Ian

 

[Tim K.]

You can use TransferDatabase method to transfer objects from one db to another db.

DoCmd.TransferDatabase acExport, "Microsoft Access", "YourTargetDBNameAndPath", acTable, "Table1"

Check the TransferDatabase method in Help for more details.