If you are going to use OLEDB or ODBC, you should use Client-Server approach, I mean, use SELECTs which only return the records you need, not all the tables.
>Hi Everybody,
>I need to use Visual FoxPro tables in VC++. I know about two options: ActiveX Data Objects and ODBC. I would like to use ActiveX Data Objects because users don’t need to do extra work for defining a Data Source. The problems are:
>1) It takes a long time, to open a table with (let say) 100,000 of records in VC++.
>2) To go through records and assign values to them, would take much more time than in Visual FoxPro environment.
>Do Visual FoxPro tables support OLE DB? Or they have to go through ODBC first? Does anybody have a better idea or whatever for accessing DBF tables in VC++?
>Thank you for you help,