Type mismatch error message thrown

[LMcMillan]

Code:
<snip>

Dim rstEmail As Recordset

Set rstEmail = CurrentDb.OpenRecorset("tblEmails")

Gets to the previous line of code and then throws Run-time error '13': Type mismatch.

Any suggestions appreciated, thanks.

 

[Dave Sherer]

I believe this problem is in your referencing make sure that you have the Microsoft Jet 3.5x or 4.0 checked in your refernces and that it is near the top of the list.

 

[crook_n_flail]

I too had this problem but instead of having to use the JET engine reference I had to check the Microsoft DAO 6.0 Object Library reference. This solved my delima.