Type Mismatch for dimmed Recordset

[Allen Browne]

The DAO and ADO libraries both have a Recordset object.
You need to specify which one you want, i.e.:
Dim dynTables As DAO.Recordset

More info on references:
http://allenbrowne.com/ser-38.html

 

[Duane Hookom]

The issue most likely is in the references. It might make a difference which
order the DAO and ADO references are listed.

Make sure you always explicitly reference the library
Dim dynTables as DAO.Recordset
Dim dbLocal as DAO.Database

 

[Gibson]

I am using the following code to open up a recordset but getting a "Type
Mismatch" error. This code worked fine on one computer but when I moved to
to a second computer I get the error. After some testing I discovered if I
dim the recordset as DAO.Recordset the problemis solved. Could it be a
reference issue on this machine? If so, any idea what reference is missing?
I can't compare computers because the other computers hard drive crashed,
nothing recoverable.

Dim dynTables as Recordset
Dim dbLocal as Database
Set dbLocal = Currendb()
Set dynTables = dbLocal.OpenRecordset("Tables", dbOpenDynaset)