There are several ways to do this. If you're really confident the tables will never move you can just hard code the path into the EXE and SET DEFAULT to it at the beginning of the program. This is probably a bad idea, but it is an option.

You could also put the network path in the working directory of the shortcut. This is particularly handy if you have a convenient way to set the shortcuts on all your users' machines (like Systems Management Server).

You could also point everyone at a little EXE on the network. That exe would just set the default directory and start the EXE on the user's machine. Of course you would need to know the directory on user's machine, but you may be able to standardize that.

The last method I can think of is to put a .mem file or a .dbf on the workstation that contains the path. You would just get it at startup and SET DEFAULT to the directory. I've used a that method and if the file doesn't exist the application uses GETDIR() to prompt the user to find the directory. This may give the user more lattitude than you'd like, but it means that you can just have someone delete the file and find the data manually if the data moves or the user re-maps drives.

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