Recordset error

[Neal]

Hi,
I am having a problem with recordsets. When using this code:

Dim dbs As Database
Dim rst As Recordset

Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("combined")

I get a type mismatch error message. (Combined is a table name).
Can anyone tell me why?
Thanks,
Neal

 

[Mile-O]

You are using DAO.

If you are using Access 2000 or 2002 then I think it is defaulted for ADO use.

To use DAO you will have to set references to the Microsoft Data Access Objects 3.5 or above library.

In a module, goto Tools -> References

Find the aforementioned library and check the box

Ensure its priority is above: Microsoft ActiveX Data Objects library.

 

[Neal]

It Worked!

Thanks very much.

I had referenced DAO 3.5, but it had a lower priority. I can't believe something like that would cause such a problem.

Neal