>I have a form that was designed with a data environment. The tables in the environment are in a subfolder (to the applications native folder) named "data". This approach has worked very well accross the board, allowing me to distribute the application and regardless of the name of the native folder, the data is available to the form as long as it resides in a subfolder called "data". Now I want to make this thing work as a multi-user app. The tables do not reside in a database. I assumed I could just use the "SET DEFAULT" command to change to a folder on the server and everything would work just fine as long as there was a subfolder called data. What I find is that once the application is run, the data environment looks the in app's native folder for the "data" folder and all the tables there. Looking at the data environment, I can't change the data source. Is there a way to do this withoug using a database? I want to just be able to enter a new location and have the data
>environment look there for the "data" subfolder and all its tables!
>
>Help...
>
>jd

You can hack the .scx by backing it up first (make copies of the .scx and .sct), then using it as a table -- use myform.scx. Look for any records whose *class="cursor"*. In the properties of these records will be info on what table is being used including the relative path. Change this to what you need. You will probably find this to be a pain to do.

If everything is consistent, you can use StrTran() function to do these changes with a replace command --

replace properties with strtran(properties, "old path", "new path") for upper(class) = "CURSOR"