Incompatible recordset type

[Dean]

I continually get an error message indicating that the
recordset object variable that I'm using is of the wrong
type. I'm trying to use two different types of
recordsets - ADODB.Recordset and a TableDef recordset.
the ADODB recordset pulls data out of a SQL Server DB and
then I load that data into the table def recordset
contained in the Access Db.

However, with both ActiveX Data Objects Library and DAO
Object Library referenced, this seems to cause confusion
in the Access application - it seems to think I'm using an
ADODB recordset when I'm trying to use the tabledef
recordset. Can someone provide some insight with this?

TIA
Dean.

 

[Wayne Morgan]

When you Dim the objects, specify which they are

Dim rst1 As DAO.Recordset
Dim rst2 As ADODB.Recordset