Recordset Type Mismatch Error
Or you could remove the reference to ADO if you aren't using it.
Both DAO and ADO have a recordset object so if you use both you need
to disambiguate your code as you discovered.
--
Joe Fallon
Access MVP
Quote:
> I needed to do
> Dim rst As DAO.Recordset
> Thanks anyway,
> Roger
> > Can anyone tell me why I get the error below? I am using Access 2002 in
> > Access 2000 file format.
> > Dim dbsA As Database, rst As Recordset
> > Dim strSQL As String
> > Set dbsA = CurrentDb
> > strSQL = "SELECT * FROM WebPages ORDER BY URL"
> > Set rst = dbsA.OpenRecordset(strSQL) *** Get Run Time Error 13: Type
> > mismatch here
> > Thanks,
> > Roger
