>>Do you have 3 copies of the data or just different data in different subdir?
> Different Data in different subdirs
>
>>Do you include the tables in your DE?
>If DE is database environmnt then yes/no. See we used to open it in the GUI DE of the form but decided to change to doing things programatically in the beforeopentables event. So it can be split between GUI DE and Beforeopentables
event. Why do you ask?

Well, If you use the DE to store the locations to the tables and the tables are not in the same dir as in development then a problem finding the tables can happen if you don't change the path to the tables before you call the opentables. For example in my load for a form i do a

IF VARTYPE(oApp) = "O"  && The Application Object exists
  * Set the paths for the tables in the DE
  This.SetDataPath()
ENDIF
* Open the Tables
This.DataEnvironment.OpenTables()

As for the error codes I've be looking at...
> 1) One ERF is caused by a call to a user defined function in the main.prg
> The function does the select with no explicit use before.
> 2) Another ERF is on a form. The tables are open in the beforeopentable
> event. Use (qData_Cur+"Master") In 0 Order Tag Loanno
> 3) This ERF occurs on a form. The tables are open in the beforeopentables
> event. There is a set datbase on this form
> Set Database To &qDATA_CUR.DriData
>Now that I've written all this it occurs to me that maybe your suggesting not opening them in the DE at all including in the beforeopentables event?

Well, I open all tables/views in the DE I just set the path if it is different before I call the opentables..
>
>>Do you open the tables up that are part of your SELECT in the current data >session?
>Yes the tables are opened with a use statement in the beforeopentables event of the same form where the SELECT occurs. In fact, it wouldn't surprise me if this happens all over the place. What does this indicate?
>
>>If I have data that can be in more than one place I do a bit in the load of >the form to set the DE paths to the correct place...
>I'm slightly unclear on what you mean here. Is it a global variable that you are using or is there somekind of foxpro variable for it?
>
>thanks