>>>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.....