>>>>>>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?
>
>Yes, I think.


it still makes me point :(

select client.*,acc.status;  &&acc is the remote table
from;
"C:\Work\acc";
inner join mainbase! client.clientid;
on acc.clientid =client.clientid

and when i save the path 2 a variable it give me an error
something like..cannot be used there