What I do is to simply rename my development data directory while production testing.

>I have a VFP9 form with a data environment that I add a few tables to. The form works great. My only problem is that when I run the production app on my dev pc, the form always opens up the development tables in it's data environment and not the production tables.
>
>The data always reside in a directory separate from the app. My app always SET PATH TO the data directory so the tables can be found. But since I have rights to the dev drive, my production app always opens the development tables. I assume that's because of the data environment.
>
>All other users that don't have access to the development drive always open the production tables when they run the app. This is the behaviour I am looking for.
>
>I assume that the data environment searches for the tables as defined in the DE then searches the PATH() for the tables.
>
>Is there a way to remove the path from the data environment? I only want my app to find the tables via the SET PATH statement.
>
>Thanks,
>
>Jerry