>Hi,
>My app has all free tables and every form's data environment is empty. My users are all on one campus, but on different networks. Some have Novell, some have NT, and some have Pathworks. I have no idea what their drive mappings are going to be. So, there is a form in my app where the user can enter the PATH to the data like: "M:\CONFIG\". Then the app carries the path as a variable. The path is stored in a field in a small table at the client.
>
>When the app starts it opens the table and picks up the path:
>use clientdat
>mDatapath = clientdat.path
>
>Later on, the LoadEvent of the Parent form opens the tables:
>mDBFtable1 = mDatapath+'TABLE1.DBF'
>mDBFtable2 = mDatapath+'TABLE2.DBF' , etc.
>
>set excl off
>sele 0
>use &mDBFtable1 alias table1
>sele 0
>use &mDBFtable2 alias table2
>sele table1
>set rela to somefield into table2
>
>Questions:
>Is this a stupid way to do this?
>Will this work when I create the .EXE and carry the app to other PCs?
>
>Thanx,
>John Morga

Is your EXE on the network? If so, then I don't think you need to worry about the data path. Just put the tables in a subdirectory of the application directory and use SET PATH TO.

If you don't have a lot of files (DBFs etc) then you could put everything in one directory. Not the best organization but ok for small apps and the easiest for implementation.

-Doug-