Craig--

>CursorAdapter is not magic It will use either ODBC or ADO. Probably the quickest way will be SQL Pass Through (SPT).
>
>>What is the simplest way to access Advantage tables (ODBC, CusorAdaptor, etc). I don't need to do much more than import them into VFP tables. I was using VFP COPY FILE. That no longer works when anyone is using the app that creates the tables using Advantage.


Craig--

I got the ODBC driver for Advantage installed. The SQLCONNECT in VFP now works. SQLTABLES works. SQLEXEC(4, "EXECUTE PROCEDURE sp_mgGetAllTables()") works.

SQLEXEC (4, 'select * from insured','sam') does not work ("insured" is one of my tables)

Any thoughts?


Tim