VB6 – Declaration (VB6)

Topic

New Reply

Hi,

I have with this statement in VB6

Dim dbTest As Database
Dim rsWorker As Recordset
Set rsWorker = dbTest.OpenRecordset(“worker”, dbOpenDynaset)

When executing the form, it prompts “type mismatch”. Is there anything I missed? Thanks…

chl88

Reply | Quote

Replies

Do you have references set to both DAO and ADO, or to ADO alone? Both DAO and ADO have recordset objects, and without specific declaration (Dim rst As DAO.Recordset) the object will be interpreted as belonging to the first model in the references list. You also don’t indicate any code instantiating the database object, you just start trying to use it, which won’t work.

Reply | Quote

Thanks for the advise…

chl88

Reply | Quote

Thanks for the advise…

chl88

Reply | Quote

Do you have references set to both DAO and ADO, or to ADO alone? Both DAO and ADO have recordset objects, and without specific declaration (Dim rst As DAO.Recordset) the object will be interpreted as belonging to the first model in the references list. You also don’t indicate any code instantiating the database object, you just start trying to use it, which won’t work.

Reply | Quote