### Set Location command

Use the Set Location command to change the location of a database that is active in a report. The Set Location command provides a simple way to indicate the new name or location of database files. 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 following guidelines apply:

- If you are moving only one table, the Set Location command can convert it to the same type or any other type of data source.
- If you are moving more than one table, the Set Location command can convert all of the tables to the same type of data source. To move more than one table to a different data source, use the Convert Database Driver command.

Note: This command does not physically move the database or databases. It simply directs Seagate Crystal Reports to look for the database or databases in another location than the one originally specified when setting up the report.

###### Related topics

Changing the ODBC data source accessed by a report

Set Location dialog box

Using the Set Location command

Using the Set Location process

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com