Access O365 crashes while filling Excel with automation / VBA

0

Since a few days (last Office 365 / 2016 update) my Access application crashes spontaneously while filling in an Excel sheet. The crash happens also in Debug, spontaneous without any error. It looks like it happens when trying to enter a value in a range-object (cell), but no clue..

Eventlog (sorry, Dutch):

Naam van toepassing met fout: MSACCESS.EXE, versie: 16.0.12827.20336, tijdstempel: 0x5edad85e Naam van module met fout: VBE7.DLL, versie: 0.0.0.0, tijdstempel: 0x5ea725ac Uitzonderingscode: 0xc0000005 Foutmarge: 0x0012a27f Id van proces met fout: 0x3940 Starttijd van toepassing met fout: 0x01d63f55c6f18f41 Pad naar toepassing met fout: C:\Program Files (x86)\Microsoft Office\Root\Office16\MSACCESS.EXE Pad naar module met fout: C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL Rapport-id: beade252-a201-43dc-8afc-679995e130c1 Volledige pakketnaam met fout: Relatieve toepassings-id van pakket met fout:

Anyone experiencing VBA-issues since last update?

vba
ms-access
asked on Stack Overflow Jun 11, 2020 by Farono-development • edited Jun 11, 2020 by braX

1 Answer

0

It could very well be that you have been hit by a recent bug:

Access VBA/DAO code may crash or report incorrect data for Decimal columns

If so, notice the included link for a temporary work-around.

answered on Stack Overflow Jun 11, 2020 by Gustav

User contributions licensed under CC BY-SA 3.0