CopyObject with Linked table

[Ripper]

I have a table (linked) that stores information that is only used in half of
the year. I want to make a "spring cleaning" macro that copies the table,
for backup, and then clears the table.

I used the CopyObject table command and it made a copy of the table in the
FE, but not the BE of the database.

How do I copy the table in the backend?

 

[Nikos Yannacopoulos]

Ripper,

The CopyObject action in the macro design view, has an argument called
Destination Database. Use that argument to provide the full path and
filename of the BE.

HTH,
Nikos