>My application contains two databases:
>
>One for tables which is stored on the network with the application
>
>The other for views, created programatically in my MAIN program and stored on the local drive.
>
>After copying the app to the network drive and attempting to run it, some forms containing views access the local view database correctly, others give the error 'file does not exist' when the form is launched and it attempts to open a view.
>
>BTW: When running the application from my local drive, all forms work correctly.
>
>I suspect pathing problems and tried (without success) adding the local drive and directory where the 'VIEW' database resides to the SET PATH command in my MAIN program.
>
>Todd
WAG, maybe it cannot find view's base tables?
--sb--