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?

 

[DaveMD]

One thing to check on this, if you are on a recent version of Access (such as version 16), DAO is now defined as part of the reference to "Microsoft Office 16.0 Access database engine Object Library" where you should be able to remove your separate reference to DAO 3.6 to avoid any conflicts.

 

[BlueSpruce]

And how is db defined?

Dim db As DAO.Database
Set db = CurrentDb

I just imported all objects to a blank new mdb, thinking it might be corruption, but no luck

 

[BlueSpruce]

One thing to check on this, if you are on a recent version of Access (such as version 16), DAO is now defined as part of the reference to "Microsoft Office 16.0 Access database engine Object Library" where you should be able to remove your separate reference to DAO 3.6 to avoid any conflicts.

They're 2003 mdb's being opened with A2003, not A2010 or newer editions.

 

[tvanstiphout]

They're 2003 mdb's being opened with A2003, not A2010 or newer editions.

In #1 you wrote: "need to be migrated to accdb"
So do that, and make sure you have the 4 standard references in their normal order (create a new db to be sure), and remove the DAO 3.6 reference.