>Is is possible to change what the location of the tables are using the data environment depending on how an application is ran. What I a trying to do is to use the DE but I have to be able to point the tables to a production drive location for all of the end users to access, but, when I need to work on issues I need to run the application looking at backup data. What we have now is all the tables opening and setting relations in the load of the form with a variable pointing to the different directions. However, there is quite a number of tables getting loaded and the form is beginning to drag on startup. Any suggestions?
>
>Thanks in advance
>Kelly

Kelly,
IMHO 'set path' is the easiest solution. If the original folder doesn't exist (rename it) :

set path to ('c:\myPath1')
do form xxx

set path to ('c:\myPath2')
do form xxx

or :
open data 'c:\myPath1\myDatadbc'
do form xxx

This works very well for me with private datasessions.
Cetin