>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?

To ensure that you always point to proper database/table, you should reset DE.CursorX.Database properties in all Form.DE.BeforeOpenTables events (it can be some generic method). Also, you application should have some app object property to store database path.