CopyObject with Linked table

R

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?
 
N

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
 
Top