>>>>Hello all!
>>>>i created a view that used a table in some far away folder totally for something else. it works but for every time i open the form that uses it. I have to point to it. Im gonna try a remote view but when i make it it says ...Connectivity error:{microsoft][ODBC Driver Manager] Data source name not found and no default driver specifited
>>>
>>>What is the type of remote table?
>>>Is it VFP Table or you use some other DB?
>>>If it is VFP table you don't have to use RV, You could use Local View and use full path to that table.
>>
>>
>>reallyyyy where do i specify the full path...it is a VFP table
>
>I your View definition:
>

>lcFullPathAndTableName = "c:\TestMe\Test"
>
>CREATE VIEW AS;
>SELECT ....... FROM (lcFullPathAndTableName);
>WHERE.....
>

u mean that is in the "view SQL" of the view?