Treeview crashes after 1906 update

Anonymous
2019-06-17T13:26:51+00:00

Hi there,

Since updating Office to Version 1906, Treeview cant seem to handle more than a few thousand nodes. I have a database with nearly 50K records that now crashes every time I try to run it. Does anyone else have this issue, if so is there a fix?

Thanks in advance.

Darren

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

26 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-06T13:38:27+00:00

    Perhaps this may be a work around until Microsoft release a fix.

    Have a Win 10 system backup from Dec 2018 where I found an MSCOMCTL.OCX (version 7.0.52.6282) and replaced the MSCOMCTL.OCX (version 7.0.53.40207) in the directory "C:\Program Files (x86)\Microsoft Office\root\vfs\SystemX86".

    After that my Access apps (ver. 1907) with Treeview controls happily jumped to live again.

    A note:

    In VBA-Tools/references the MSCOMCTL.OCX (version 6.1.98.34) is still "registered" in C:\Wondows\SysWOW64, but it Access doesn't seem to care.

    Renamed the MSCOMCTL.OCX file in SysWOW64 but the controls in the Access apps works anyway.

    Note 2 - maybe not really important but anyway:

    In the Report.wer file in "C:\ProgramData\Microsoft\Windows\WER\ReportArchive" found in Windows logs, Programs after every Access crash, it says the MSCOMCTL.OCX is loaded from "C:\Windows\System32".

    Tried copy 32-bit MSCOMCTL.OCX (version 6.1.98.34) to both "C:\Windows\System32" and  "C:\Program Files (x86)\Microsoft Office\root\vfs\SystemX86".

    Regsvr32 did register the ocx files but it didn't work in Access.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-07-31T08:34:17+00:00

    Yes - the 1908 fix will work for all the Office Applications that can use the TreeView control.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
    2019-06-19T13:20:16+00:00

    Is there a way you can isolate the issue to the bare minimum and post it in a public place (like a free OneDrive account) so we can take a look?

    Presumably this would involve a table with anonymized data, a form with treeview and the code to load it.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-06-19T07:28:45+00:00

    Hi Tom,

    Thanks for your response, I tried using data from a month ago to no avail. I also double checked and there's nothing wrong with the data/code/files (I downloaded VB6 Common Controls and re-registered it). Long story short, I reverted Office back to Version 1905 and the issue went away.

    Was this answer helpful?

    0 comments
  5. Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
    2019-06-17T16:36:08+00:00

    I am assuming you are referring to MSFT's Treeview control. What is the version of comctl32.ocx in the syswow64 folder?

    I bet you it has not changed in years, so it is not the culprit. Your VBA code presumably has not changed either. Maybe the data has? Try again with data from last month.

    Also decompile the application.

    Also, are other users seeing this?

    If you want a workaround, I have heard that there are other treeview controls out there. They may have a different api so may take a bit of effort to implement.

    Was this answer helpful?

    0 comments