>Hello All,
>I've just tried using the data environment of the form to open the tables needed for the form. In my main program, I issue the open database command and have set the default in the samo program.
>
>I created the exe file and moved it out to the netowrk for testing. Sure enough I get the message of unable to locate the tables, LOcate, Ignore, Cancel and Ignore all(I think that was the last alternative!).
>
>I reopen the form, open the data environment, select properties of one of the tables and sure enough, there, in the property called database I find the hard code of the path of the table with all the colons and backslashes of DOS.
>
>I cleaned out the data environment and in the load returned ti the fox2x standard of IF NOT USED etc and SET RELA TO for all the tables.
>
>Is this normal behavior in the data environment?? If so, is there a workaround for this??
>
>I'm using VFP5
>
>Thanks
>
>Sandy

DE is OK. You should reset Database property for all DE.Cursors in DE.BeforeOpenTable event. Doing this, you can forget about SET DEFAULT/PATH etc.