>*****************
>
>lcconnstr = 'Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;' + ;
>> 'SourceDB=C:\MyDir\Mydatabase.dbc;Exclusive=No;Deleted=No;' + ;
>> 'BackgroundFetch=No;'
>>lnconn = sqlstringconnect(lcconnstr)
>>HTH.
>**************
>This would allow the use of remote views. Do you know if the access times would be significantly slower than with local views for tables having 80K - 15 million records?
I believe it would be because you are adding the extra overhead of the ODBC driver insetad of the native VFP data engine.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao