Bug KB5002160 - Microsoft Access database engine 2016

Question

After install update KB5002160 is problem with initialize DB engine 2016. My program is freezing.

_DBEnginePtr dbEngine;  
DAO_CHECK_ERROR(dbEngine.CreateInstance(__uuidof(DBEngine)), AFX_DAO_ERROR_ENGINE_INITIALIZATION);  

I have had a similar problem: https://learn.microsoft.com/en-us/answers/questions/450361/function-getacedaoversion-stoped-working-after-off.html

Could you repair it?
Thank you

Zdenek

Answer 1

We have exactly the same problem. Reinstalling "Microsoft Access 2016 database engine” works just temporarily until the next Windows Update detects that KB5002160 isn’t installed and installs it again.

The stack of our application looks like that if KB5002160 is installed:

Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\ACEDAO.DLL'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\Mso20win32client.dll'. Cannot find or open the PDB file.

… and if not:

Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\ACEDAO.DLL'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\Mso20win32client.dll'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\Mso30win32client.dll'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\Mso40UIwin32client.dll'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\Mso99Lwin32client.dll'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\MSO.DLL'. Cannot find or open the PDB file.
Unloaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\MSO.DLL'
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\MSO.DLL'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\ACECORE.DLL'. Cannot find or open the PDB file.
Unloaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\ACECORE.DLL'
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\ACECORE.DLL'. Cannot find or open the PDB file.
Loaded 'C:\Windows\System32\d2d1.dll'. Cannot find or open the PDB file.
Loaded 'C:\Windows\System32\d3d10_1.dll'. Cannot find or open the PDB file.
Loaded 'C:\Windows\System32\d3d10_1core.dll'. Cannot find or open the PDB file.
Loaded 'C:\Windows\System32\d3d10warp.dll'. Cannot find or open the PDB file.
Loaded 'C:\Windows\System32\davclnt.dll'. Cannot find or open the PDB file.
Loaded 'C:\Windows\System32\davhlpr.dll'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\VBAJET32.DLL'. Cannot find or open the PDB file.
Loaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\EXPSRV.DLL'. Cannot find or open the PDB file.
Unloaded 'C:\Program Files\Common Files\microsoft shared\OFFICE16\VBAJET32.DLL'

So the implicit loading of 'C:\Program shared\OFFICE16\Mso30win32client.dll’ and others doesn’t happen if KB5002160 is installed.

Answer 2

An alternative is to install the older version of Database Engine:
https://www.microsoft.com/en-us/download/details.aspx?id=39358
https://www.microsoft.com/en-in/download/details.aspx?id=13255
then it is registered older version.

Curent version AceDao.dll is in:
Počítač\HKEY_CLASSES_ROOT\Wow6432Node\CLSID{CD7791B9-43FD-42C5-AE42-8DD2811F0419}\InprocServer32

Answer 3

Same problem here (DbEngine freezing when opening a database) ...

Answer 4

same problem from python:

$ python
Python 3.8.10 (tags/v3.8.10:3d8993a, May  3 2021, 11:48:03) [MSC v.1928 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import win32com.client

>>> win32com.client.Dispatch("DAO.DBEngine.120")

hangs, has to be killed by hand

Answer 5

Same problem here (DbEngine freezing when opening a database) Process runs in the background and has to be killed by hand.
No visibility on screen of the Instance running in a Window.