Unable to load MS DAO 3.6 Object Library

[Leesha]

Hi,
I've created a new Access DB and am using code to send emails that is working fine in a similar database. I went into the the reference library to be sure that they were the same, however I am unable to load the Microsoft DAO 3.6 Object library without getting the error "Error in loading DLL". If I try to to run the email code I get an error point to Dim dbs As DAO.Database. The current reference library is attached.
Thanks,
Leesha

[HansV]

Hi Leesha,

DAO 3.6 was the version of DAO for .mdb databases. The DAO library for .accdb databases is

Microsoft Office 16.0 Access database engine Object Library

S2542.png

[Gasman]

That last one is ADO ?

Does this help? I thought DAO iwas included by default in later versions?, after 2003?

https://stackoverflow.com/questions/716 ... ferenced-d

[Leesha]

Hi Hans,
That did the trick! Question, I have two older accdb db's that use the old 3.6 dll. If I update them will that adversely affect the code or should I leave as is since it's working?
Thanks!
Leesha

[HansV]

I'd remove the reference to the DAO 3.6 Library and set a reference to the Microsoft Office 16.0 Access database engine Object Library instead.
The code should not need to be updated.

[Leesha]

Thanks!