archive Access table to archive directory autonaming with seqential no 1

[ruzi55]

I run a make table query on data held in several tables in the database. The make table is a release table of data to be imported into Sage, each time the query is run the contents of the release table is deleted. SO as part of the procedure when the release table has been created I need to be able to "archive" a copy of it to a designated archive directory, as this process happens frequently I would like to the "archived" version to be named with an autonumber.

Is this possible and if so how?

Many thanks

 

[BNPMike]

If your table comes from other data in the database surely you don't need to archive it. You can always recreate the data from the database again if you need to.

You can programmatically copy tables with OutputTo or TransferDatabase actions. See Help for details.