Recordset error

[maksim]

I have a question about recordset error. If somebody can reference a code that uses recordset, it would be helpful.

strSQL = "SELECT * FROM Proffessor"
Set dbsProject = CurrentDb
Set rstProf = dbsProject.OpenRecordset(strSQL) this line gives type mismatch error.

 

[BillPower]

This might help!

While in the Visual Basic Editor, from the menu, select Tools>> References. If you have both Microsoft ActiveX Data Objects and DAO object library checked, make sure DAO object library comes before Microsoft ActiveX Data Objects.

If this is the case uncheck Microsoft ActiveX Data Objects then check it again so that it now appears in the list after DAO object library. This a known problem

http://support.microsoft.com/default.aspx?scid=KB;en-us;q181542

 

[maksim]

Thanks a lot. It helped.