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
Unable to load MS DAO 3.6 Object Library
-
- BronzeLounger
- Posts: 1495
- Joined: 05 Feb 2010, 22:25
Unable to load MS DAO 3.6 Object Library
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Unable to load MS DAO 3.6 Object Library
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
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
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 120
- Joined: 22 Feb 2022, 09:04
Re: Unable to load MS DAO 3.6 Object Library
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
Does this help? I thought DAO iwas included by default in later versions?, after 2003?
https://stackoverflow.com/questions/716 ... ferenced-d
Using Access 2007/2019.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
-
- BronzeLounger
- Posts: 1495
- Joined: 05 Feb 2010, 22:25
Re: Unable to load MS DAO 3.6 Object Library
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
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
-
- Administrator
- Posts: 78686
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Unable to load MS DAO 3.6 Object Library
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.
The code should not need to be updated.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1495
- Joined: 05 Feb 2010, 22:25