Steven,

This is what I do:

My 2 live applications are on N:\ and R:\. Within each are the exe and the tables. There are also some tables in a subdirectory of each.

In my application I refer to the data with USE MyTable or USE .\MySubdirectory\MyTable. (The dot notation uses relative pathing - it looks for the table from wherever it is.) If I am running the production app (living in the production directory) it looks at production data.

There are no "N:\", "R:\", or "Q:\" hard coded anywhere in my programs. If our network people decide that N:\ has gotten full and need to move stuff, all I need to do is copy my exe and tables and subdirectories, and off we go.

My development/test directory has a subdirectory for each app (Q:\MyNApplication and Q:\MyRApplication) Within each are copies of the live data which I can play with (add, delete, change records in the process of testing) including the subdirectories. I can also change table structures to test a new field, etc. All of the program source code lives on Q:\ within the appropriate directory. I can grab a fresh copy of production data any time, or create a special set of test data which covers every possible scenario.

When I've made and tested changes, I copy a new version of the application over to the appropriate live directory. If necessary, I make appropriate table structure or index changes then too.


>I am working on an application using VFP 6.0. It is in a network environment. I have a development directory and a live directory. How do I develop my app with tables and forms in the dev dir and begin to make it available in the live dir at the same time. Where would my tables live so they would be accessable to both environments. The main program that sets the path, what path do I use or would I have to have a different path statement in each. I realize this may be elemantry. However, I have spent about three months on this application. It presently resids in a live directory. When something goes wrong I have to trace down all instances of the app before I can open it in a development enviornment to work on it. If you will please help.
>
>May God Bless
>S Dyke