Hi all,

Having made only one real application using VB two years ago (using ODBC connection to VFP data) i now thought that i should change it to use VFP's OLE DB driver. But i am getting an error on the last of the following three lines:

  sqlString = "select index from isolator where article = ''"  && works
  DataEnv.Recordsets("rdsIndex").Open (sqlString)              && works
  DataEnv.Recordsets("rdsIsolator").Open                       && does not work

Error message: Run-time error: '-2147352567 (80020009)':  Method 'Item' of object 'Recordsets' failed.

And if i look at the Err object in debug window in VB the error number for LastDllError is 6 (to many files open) ??
All other record sets in the application works and is "SQL-select statements", but this one is "Table".

Any ideas ?