Proofing lineup order of library references (4 Viewers)

[BlueSpruce]

I received several broken 2003 apps that need to be migrated to accdb. I noticed

Dim rs As Recordset

errors and when I checked the references lineup, ADO was listed first, so I put DAO 3.6 first and it's still throwing error. Then I fully qualified

Dim rs As DAO.Recordset

and no luck. I checked other code, like

Dim db As Database

fully qualified it to DAO.Database and still errs. Any idea what's going on here?

 

[GPGeorge]

What exactly is the error and error description?

 

[BlueSpruce]

What exactly is the error and error description?

Runtime error '13': Type Mismatch when setting rs = db.OpenRecordset("tblQuotes", dbOpenSnapshot)

I checked DAO 3.6 and it's correctly COM registered.

 

[GPGeorge]

Runtime error '13': Type Mismatch when setting rs = db.OpenRecordset("tblQuotes", dbOpenSnapshot)

And how is db defined?