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