Hi Mike
Have you tried this without the vfp ole db provider present? I have the vfp odbc driver installed from mdac 2.5. After installing mdac 2.6, the vfp driver was still be available, but none of the VFP/ADO code (using MSDASQL) worked any more. I'm using the same code that opened ADO connections just fine with mdac 2.5. I assumed that this meant that I needed the vfp ole db provider.

Regards
Bill

>Not true; MDAC 2.6 just doesn't install the driver. You can still use the driver with ADO via MSDASQL a. k. a. the OLE DB Provider for ODBC.
>