>I am using VFP 3.0 for Windows.
>
>Here is a problem that I have been struggling with for a while...
>
>When I am creating a form or a report and use the data environment to access the tables needed, should I add the tables from my test environment or from my production environment?
>
>It seems that if I point to the test tables that the form wants to continue to access those tables even after I have promoted the exe into the live environment (really just a different directory on the file server).
>
>Can anyone tell me what I should be doing?

The whole path to the tables in a Form.DataEnvironment is in the DataEnvironment.Database property. You can modify it in the DE.BeforeOpenTables method or in the form.Load, which is what I do, because the code is in my formclass.Load. Set the DE.AutoOpenTables = .F. My formclass calls a custom class which loops through all the cursors in the DE and sets the path in each Cursor.Database to CURDIR(), which is where I keep everything.

I don't use the DE in reports.