I have noticed some serious problems when using ADO to access VFP tables.
a) The MaxRecs property does not work. ADO ignores it when you wish to return only a few records in your cursor. It always returns all that match your SQL statement.
b) The RowCount property always returns -1.
c) It seems to lock the whole table and releases it only when you are done.
d) You cannot open the tables as Dynamic.
e) It is slow in selecting and adding records to large tables (Over 20,000 records)
I also used it with Pervasive (Btrieve) database and I experienced the same problems. To me this means that MS again is not interested in supporting this thing for all its products or anyone elses. I guess ADO only works properly with SQL Server.
Has anyone else had other problems when using ADO and VFP tables? 1
Costas