>I have an existing exe running off of a server, with the tables in subdirectories below the exe directory (as discussed in an earlier thread - to permit security right assignments to the various tables).
>
>As I work on updating the exe to VFP6, I've seen discussions here in UT about placing a copy of the exe on each users PC to speed performance.
>
>How do I ensure that the exe can find the tables on the server?

We use an INI file that is created during setup with an entry that points to the data directory. We read the file on app startup, then set paths accordingly. We also point private datasessions to it in the BeforeOpenTables event of each form's datasession. We keep the default directory pointed to the local machine, for temp files, etc.

There are many ways do do it, this is only one.