>Hi,
>
>I would like to know which is the best approach to develop data access, ODBC or ADO in MTS. What are the pro and cons of each of the approaches ? Thanks.
>
>Regards,
>Kueh.

The best approach really depends on your needs. VFP does not fully support ADO record sets. For example, you'll need to convert to/from ADO to VFP cursor to use the data in a grid. However, if you want to create one solution that works from VFP, the web, Excel, etc., MTS with ADO may be better.