Results 1 to 4 of 4
  1. #1
    Quarak is offline Novice
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    2

    Random crashes on Access 365 with SQl Express linked tables

    A few weeks ago my access databse started to occasionaly crash when moving from one record to another seeming at random.
    I have logged the sequence of records I have stepped through until it crashes, relaoded the database and it does not replicate on the same sequence of records.

    After checking the reliability history the crash dump in there is always as follows.

    Faulting Application Path: C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE

    Problem signature


    Problem Event Name: BEX64
    Application Name: MSACCESS.EXE
    Application Version: 16.0.14527.20234
    Application Timestamp: 61787b90
    Fault Module Name: ucrtbase.dll

    Fault Module Version: 10.0.19041.789
    Fault Module Timestamp: 2bd748bf
    Exception Offset: 000000000007286e
    Exception Code: c0000409
    Exception Data: 0000000000000007
    OS Version: 10.0.19041.2.0.0.256.48
    Locale ID: 2057
    Additional Information 1: 39fa
    Additional Information 2: 39fa08bf272fbf10bb6f5dc813f316f9
    Additional Information 3: 5d04
    Additional Information 4: 5d04657561355a579751de820685112c

    The day the crashes started the following updates had been installed.
    Installation Successful: Windows successfully installed the following update: 2021-10 Cumulative Update for .NET Framework 3.5 and 4.8 for Windows 10 Version 2004 for x64 (KB5005539)
    Installation Successful: Windows successfully installed the following update: 2021-10 Cumulative Update for Windows 10 Version 2004 for x64-based Systems (KB5006670)

    This happens on both my home PC's and started at the same time, the updates had been installed on both machines.

    I've tried decompiling, compiling and compacting.
    I have tried re-installing the Windows 10 SDK as a few other problems referencing ucrtbase.dll said that had worked for them.
    I'm currently working through all the code in debug to see if I can find a particular peice of code that causes the crash but this very slow as there is a lot of code and teh crashes happen relatively rarely.

    Does anyone have an ideas of how best to troubleshot this?

    Click image for larger version. 

Name:	Project References.png 
Views:	30 
Size:	22.0 KB 
ID:	46659

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    We had some weird crashes on a newly installed machine a number of weeks ago.
    A office full repair, followed by a proper reboot finally cured it.

    It looked as if the most recent office update hadn't completed properly.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Quarak is offline Novice
    Windows 10 Office 365
    Join Date
    Nov 2021
    Posts
    2
    Thank you but I have tried that and the same problem is happening on more than one PC starting at a similar time.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    I don't know whether this will help but you should be using the Microsoft Office 16.0 Access Database Engine Object Library instead of the very old DAO 3.6 Object Library which dates back to A2003 or earlier.
    Also the Common Controls Library can be problematic in recent versions of Access and, IIRC, doesn't work in 64-bit Access.
    Try removing any other references that you don't actually need
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Crashes in Design View for Tables
    By Nico80000 in forum Access
    Replies: 4
    Last Post: 09-10-2021, 04:30 PM
  2. Express to match two tables
    By SONCH in forum Queries
    Replies: 1
    Last Post: 05-15-2018, 01:12 AM
  3. Replies: 6
    Last Post: 04-18-2018, 06:56 AM
  4. Replies: 17
    Last Post: 04-09-2018, 04:39 PM
  5. Replies: 2
    Last Post: 04-29-2016, 03:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums