locked
Error in compiled mde, not in uncompiled mdb RRS feed

  • Question

  • I have a problem with my compiled mde's after the latest round of Microsoft updates.  

    This is a baffling issue...when I open the UNCOMPILED database (.mdb file) everything works fine.  However, if I open the COMPILED (.mde file) database, I get the error "Error Accessing File. Network connection may have been lost."  When I click OK, I get a second error message saying "The expression you entered has a function name that {database name} can't find.", followed by a Macro Single Step dialog.

    If I attempt to compile the mdb, I get a type mismatch error on a line of code that attempts to populate a recordset.  I tried changing the variable declaration explicitly to both an ADODB.Recordset and a DAO.Recordset.  Both had the same problem.

    Thursday, March 10, 2016 7:14 PM

Answers

  • The update KB 3085515 for Office 2010, released on March 9, 2016 may cause problems with Access ACCDE/MDE databases, with wizards and/or VBA in Access 2010.
    Microsoft is aware of the problem and will try to correct this as fast as possible. In the meantime, the update won't be offered by Windows Update anymore.
    If you experience problems with Access 2010 after installing KB 3085515, please remove this update.

    See You may encounter errors with your ACCDE/MDE files and/or wizards after installing the March update for Office 2010 (KB3085515)

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by dmcduck Thursday, March 10, 2016 8:54 PM
    Thursday, March 10, 2016 7:20 PM
  • I don't think the patch was for the 64-bit version of Office only.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by dmcduck Thursday, March 10, 2016 8:54 PM
    Thursday, March 10, 2016 8:27 PM

All replies

  • The update KB 3085515 for Office 2010, released on March 9, 2016 may cause problems with Access ACCDE/MDE databases, with wizards and/or VBA in Access 2010.
    Microsoft is aware of the problem and will try to correct this as fast as possible. In the meantime, the update won't be offered by Windows Update anymore.
    If you experience problems with Access 2010 after installing KB 3085515, please remove this update.

    See You may encounter errors with your ACCDE/MDE files and/or wizards after installing the March update for Office 2010 (KB3085515)

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by dmcduck Thursday, March 10, 2016 8:54 PM
    Thursday, March 10, 2016 7:20 PM
  • Had the exact same issue.  Uninstalling update KB 3085515 resolved the problem.  Thanks for the speedy reply

    George McKee

    Thursday, March 10, 2016 8:07 PM
  • It is my understanding that this patch applies to the 64bit version of office.  We have 32 bit...is there a corresponding update for it?
    Thursday, March 10, 2016 8:08 PM
  • I don't think the patch was for the 64-bit version of Office only.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by dmcduck Thursday, March 10, 2016 8:54 PM
    Thursday, March 10, 2016 8:27 PM
  • Network folks found the 32-bit version and removed it.  Problem solved.  Thank you very much!
    Thursday, March 10, 2016 8:55 PM
  • Note that an MDB may also fail if this Microsoft Office Update is installed. That can occur if the MDB is referencing an MDE.

    The offending file is the VBA7.DLL that was replaced in this update. The DLL was not set with binary backward compatibility correctly. It also impacts some of the Access Wizards that are also MDE/ACCDE files.

    I wrote a blog post that discusses this update in more detail, what it impacts, and how to uninstall it with step-by-step illustrated instructions for Windows 10 and 7/earlier.

    http://blog.fmsinc.com/microsoft-update-kb3085515-for-office-2010-causes-access-accde-mde-databases-to-crash/

    Hope this helps.


    Luke Chung
    Microsoft MVP
    President of FMS, Inc.
    Blog Facebook Twitter

    Monday, March 14, 2016 2:33 AM