Copy linked table to another back end (1 Viewer)

[Bob]

Hi there

I have the usual setup with a front and back end.

I want to copy three of my tables from the back end to another database (backup) at regular intervals. When using docmd.CopyObject and docmd.TransferDatabase it is the link that get copied (naturally) and not the table itself.

Any suggestions ?

 

[Bob]

Found the solution elsewhere. In case someone is looking for the same it was Bob Larson (MrExcel, MVP) who provided a solution that works in my case:

dim objApp as Object

set objApp=CreateObject("Access.Application")
objApp.OpenCurrentDatabase("C:\Somepath\SomeDB.accdb")
objApp.DoCmd.CopyObject "C:\DestinationDatabase.accdb",,actable,"SourceTableName"
objApp.CloseCurrentDatabase
set objApp=Nothing