>Good question. The application will be scaled to SQL Server 2000. I'm using ADO to minimize rewriting the database access code.

You should also consider using either sql pass-through techniques and/or remote views. At least you would be dealing with the data from VFP cursors instead of the recordset object. Another issue with classic ADO is that it has essentially been made obsolete by ADO.NET.