Export Linked table to another db using VBA

[Ymesei]

I'm trying to create a function that will export a linked table from the current db into another one. The only problem is that it's exporting a link to the back end to the other db. I want it to actually export a copy of the back end table to the new db, but I need the process to be done from the Front End.

I am using the TransferDatabase method. Is there an argument that will have it do this or maybe another method that will do it this way?

Thanks in advance.
Will