Use the Set Location command to indicate the new name or location of tables that are active in a report. This is especially useful if someone sends you a report that uses a database that has a different location on your system, or if you have changed the directory or disk location of a database. In addition, the Set Location command automatically converts your database driver to the data source you have chosen. For example, you can automatically convert a direct access data source to an ODBC data source using the Set Location command.
The procedure is the same whether you are replacing all tables from a particular data source with tables of the same name from another data source, or replacing an individual table with another table.
To change the data source location