Hi Kelly,

Look at the CursorSource property of the Cursor object. I don't know if it's a good practice but I did this once in a small internal application and it worked. In the BeforeOpenTable (or Init maybe) I changed the CursorSource property according to some parameters of the global application object.

If you're using VFP8 it could easily be done in your subclass of Date Environment based on an admin table.

Hope this helps.
Sylvain Bujold

>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