Copy Linked Access Tables to Local Tables with VBA

[Access or E]

I have an MS Access database with linked network tables that I need to copy to local tables into a new database along with the front end using VBA. How would I go about doing this? Would the TransferDatabase method be the best way? Thanks in advance for advice.

 

[KitaYama]

DoCmd.SelectObject acTable, YourTableName, True
DoCmd.RunCommand acCmdConvertLinkedTableToLocal

 

[ebs17]

into a new database

Use extApp.DoCmd.TransferDatabase ... (after creating this new database).
In addition to the structure and data, the indices are also transferred.
extApp must be the reference to the Application object of one of the two backends.

 

[Access or E]

When I try the DoCmd.RunCommand acCmdConvertLinkedTableToLocal it throws a runtime error message 2046.

 

[KitaYama]

When I try the DoCmd.RunCommand acCmdConvertLinkedTableToLocal it throws a runtime error message 2046.

View attachment 106070

I just tested it and it works fine for me.
I really don't know why you receive this error.
Hopefully someone will answer.

 

[isladogs]

You can also right click any linked table and select the option to convert to local table

 

[bastanu]

Please feel free to try my utility (http://forestbyte.com/ms-access-utilities/fba-fuze/) that does just that (and you could run it in a scheduled task if needed).

Cheers,

 

[tucker61]

I know this thread is old, but I get the same error when running the code - but it works ok if i step through the code using F8.