>Check this Wiki, you could get some suggestions:
>
>http://fox.wikis.com/wc.dll?Wiki~Client/ServerTechniquesPerformance
>
>
>
>>I need to search a patient record that sits in a large Access MDB (SQL
>server later version) from a Visual FoxPro program. I can setup remote view to accessthe table. But I don't think I can take advantage of index already created in Access. And I don't think creating a temp index on the patient_id
>in Visual FoxPro in order to seek the record is a good idea (using Locate is out ofthe question). So, I am thinking about changing the code using ActiveX Data Objects sending Select query to retrieve the recordset,which I suppose the index of the MDB will be used by the OLEDB provider, am I right or wrong? Using remote view on large table is not such a good idea in this case, right?
>>Also I need to update the record too. I am using VFP6 accessing Access 2000
>MDB.
Hi Esparta,
Thanks for the response.
I tried the link a couple of time. It is not valid.

Kam.