>I have an app working on drive C with a path set to c:\appdir. Works fine.
>
>One new feature requires a query of a table on another computer on the network. At runtime I get the file open dialog instead of the query. If I use the dialog to point to the data on the other persons computer it the query works fine for the rest of the time the app is booted.
>
>I changed the path to c:\appdir ; \\othercomputer\drive\subdir\subsub
>but I get the same problem. Any ideas? It seems clear to me that the local view cannot find the data.
>
>
>TIA
>CG

I have views that call a users table that can be anywhere the application was installed at. Either local drive or network. At the start of my app I set the path so that it is in effect for the duration. Example:

SET PATH TO '\\402FS1\DATA\VFAPPS\CODE40'+'\Data;'+'\\402FS1\DATA\VFAPPS\CODE40'+'\Graphics;'+'\\402FS1\DATA\VFAPPS\CODE40'+'\Help;'+'\\402FS1\DATA\VFAPPS\CODE40'+'\Utils;'+'\\402FS1\DATA\VFAPPS\CODE40'+'\Resource'

I would suggest you examine the path right before the view is called and ensure that it is set correctly and has not been changed.