I like to keep things simple, if there is a simple way to accomplish something. I sometimes like to work on a network application on my notebook in the evening. The notebook only has a c: drive. The clients data files are on their m: drive in a directory named data.

What I do is:

Create a directory on my c: drive (example: Client). Make a subdirectory named data and put all the clients data files into this directory.

When I'm working on the clients data files in the development environment, all I have to do in the command window is type: set volume m: to c:\client

As a result, the program will now find all data files in the m:\data directory just as it would in the production environment on the clients server.

Dale


>Is it possible to set the data environment in a form (or report) so that if it is run in production, it accesses the dbc on production server but if it is run in development, it access the dbc on development box?
>
>In this particular case, dbc and all dbf names are identical. The only difference is the path to the dbc. I have tried to do this, but for some reason the data environment remembers that it got itself from development path and I can't seem to be able to re-direct it. I'm probably not doing something really simple right, but it has me stumped!
>
>Appreciate any help. - Susan