How to: Update Table and Database Links

When you move database (.dbc, .dct, and .dcx) files or a database table, the relative paths change and might break forward links and back links that Visual FoxPro uses to associate database and table files. You can reestablish links and update the relative path information to reflect the new file location.


If you want to open a table without reestablishing links for all tables in the database, use the USE command. Visual FoxPro displays the Open dialog box so you can locate the database that owns the table or delete the links. For more information, see USE Command.

You can also remove the database reference, or back link, from a table.

To update links between a database and its tables

  • Use the VALIDATE DATABASE command with the RECOVER clause

For more information, see VALIDATE DATABASE Command.

For example, the following code opens a database named MyDatabase and displays dialog boxes to help you locate those tables that are not in the locations stored by the database:


To remove the back link from a table

  • Use the FREE TABLE command.

    Caution noteCaution

    Do not use FREE TABLE to remove a table from a database if the database exists on disk; use REMOVE TABLE instead. If the database exists on disk, FREE TABLE might render the database unusable.

For more information, see FREE TABLE Command.

See Also

Community Additions