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

>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