Mike,

One easy way is to include a file with the workstation installation that indicates where the data files are located. This could be a text file, a DBF, or a .mem file. The file would just contain the path to the data files. If the file doesn't exist, your application can prompt the user to find the data files using the GETDIR() function, then create the file. You can also prompt if the path in the file does not exist or does not contain the data. This makes it easy to deal with the data being moved.

If a user need to switch between data sets (e.g., for testing), all he or she needs to do is delete the file with the path and run the application.

>I develop applications at home on a stand alone machine.
>When I take the application to a customer site, the database tables reside on the network server. How do I change all of the links to the data tables in the application?
>
>The problem is this:
>
>I need to make a version of the executable that will reside locally on a person's hard drive. I have a WAN connected via an ISDN link, and to get the most speed possible, I would like to store just the necessary files (i.e. tables) on the server. This means that the executable, etc would reside locally.
>
>Any ideas on how to do this?
>
>Mike