Import Linked Table Structure

[echorley]

I would like to import a linked table from one Access database to another linked table in Access database using VBA.

I have tried to import the linked table using:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
UpdateFileLocation, acTable, "tbl_Elementary Roster", _
"tbl_Elementary Roster"

And I have tried the AcLink method to set up a link:

DoCmd.TransferDatabase acLink, "Microsoft Access", _
LinkedFileLocation, acTable, "tbl_Elementary Roster"

Neither works. Any ideas?

Thanks

 

[llkhoutx]

Are you specifying the file path and mdb name?