Do you have 3 copies of the data or just different data in different subdir?
Do you include the tables in your DE?
Do you open the tables up that are part of your SELECT in the current data session?

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



>So in my never ending search for "Error Reading File" and "Invalid Seek Offset" answers I've got a theory to bounce off everyone.
>
>When we do a SELECT in our application we usually add a Public variable path that points to the current active data for that user on the network.\
> qData_Cur = "G:\Ourprogram\OurData\"
> SELECT Code1, Desc1 FROM (qData_Cur + "CODES") INTO ....
>We do this because at some clients there are multiple data directories. The structure of the directories are identical and only the data contained in them is different. All the Data directories are used identically through the same .exe
>
>So I've noticed that often (although NOT always) if I fail to include the path
> SELECT Code1, Desc1 FROM Codes INTO...
>we receive the error reading file. Now keep in mind that it doesn't always happen at the same point, nor that this is the only situation where ERF occurs, but do you think the multiple directories would cause a problem? The directories would all be under the root..
> G:\OurQpp\Data1
> G:\OurApp\Data2
> G:\OurApp\Data3
>and all run off of the same .exe that is housed locally on the workstations. Maybe something is getting counfused or ....?????
>
>Any thoughts?