Specifying the Destination DB

The destination of reconfigured data is specified using the TO command. Some examples of the use of the TO command are:

TO DB and TO DBFILE specify that the data are to be reconfigured into an existing DB, identified by its name or that of the file containing it. The destination DB must be of the same type as the source DB, and will normally be empty, but need be. For an explanation of what happens when the DB is not empty, refer to Copying Parts of Databases.

TO NEW specifies that a new DB is to be created to receive the reconfigured data. This is the most common option for the general compaction of DBs. It is explained further in Copies and Reconfigured Copies of DBs.

Note:
The new DB will need to be added to the appropriate MDBs.