DAO Access Database updated to Office 2003

[Alan]

Existing vba 97 code has eg -dim db as database
Causes compile error in 2003
Tried to overcome this by tools - References toinvoke DAO 3.6 libray
but got error message that feature unavailble in Registry!
CAn anyone help me please

 

[Paul Ilacqua]

Alan

Try

Dim db as DAO.Database
Set DB = CurrentDB()

Default for 2003 is ADODB

Paul

 

[Douglas J Steele]

Except that there's no Database object in the ADO model, so while it's
definitely better programming practice to disambiguate declarations, it's
unlikely to make any difference in this case.

Alan said he was unable to create a reference to Access 2003, which actually
shouldn't even be required, as by default Access 2003 includes references to
both ADO and DAO (although with ADO having precedence over DAO)

Alan: A reinstall of Access might be in order. If that still doesn't work,
look for the dao360.dll file (it should be in C:\Program Files\Common
Files\Microsoft Shared\DAO) and try reregistering it using regsvr32.exe