Hi all,

I need to search a patient record that sits in a large Access MDB (SQL
server later version) from a VFP program. I can setup remote view to access
the 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 VFP in order to seek the record is a good idea (using Locate is out of
the question). So, I am thinking about changing the code using ADO 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.

Any suggestion?

Thanks.

Kam.