Using a (v old!) Access app with Access 2003 (DAO)

[Fionnbarr Kennedy]

Hi all
having just installed Access 2003 how do I use DAO? I
am referencing Visual Basic for Applications and Microsoft
DAO 3.6. The code is falling over on Recordsets. I know
they are (way!) out of date but there are Hundreds in my
application and I dont have the time to re write. Is
there another reference I'm missing?

The app runs fine until it needs a recompile when it falls
over.

Many Thanks

Fionnbarr

 

[Cheryl Fischer]

Since you already have your DAO reference set, try "dis-ambiguating" your
code when using DAO objects. For example:

Dim rs as DAO.Recordset
Dim qdf as DAO. QueryDef 'etc

or, in the list of references, move the DAO reference so that it is listed
before any ADO reference.


hth,