Copy B/E table from F/E

[SimonB1978]

Hi there,

I'd like to know if there is a way to programmatically copy a table that is on the back-end (both the original and new table are on the back-end) by running code on the front-end. I will then link that new table to the font-end.

Thank you,

Simon B.

 

[SimonB1978]

Hi again,

Since I wanted the structure only to be copied I found a way to do it.

DoCmd.TransferDatabase acImport to import the structure to the F/E and then
DoCmd.TransferDatabase acExport to export it with the new name to the B/E

Seems to work fine.

Simon B.