MS Access 2013 crashes continually on different computers.

Anonymous
2013-03-18T13:45:00+00:00

I having increasing problems with Access 2013 crashing.  Even after compacting and repairing the database it crashes all of the time - now it's crashing whenever I try to do a "save as" or when I try to exit.  It's been unstable since I started using it but it seems to be getting worse, and it happens on multiple machines. Anyone have an idea why it's constantly crashing?

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 No comments

87 answers

Sort by: Most helpful
  1. Anonymous
    2013-07-09T13:26:44+00:00

    Sorry for the delay...  I just got the eMail that you replied!

    1. Do you have both versions of Excel installed?  (You might want to use Late Binding for the Excel library, that way no worries about versions.)
    2. What other DAO Libraries?  (If you are trying to set a Reference to the DAO Library you don't need to, it's included in the Microsoft Office Access database engine Object Library.)
    3. Does each Module have...

    Option Compare Database

    Option Explicit

    ...at the very top.  If it does not you need to add it and Debug>RE-ompile to check for errors.

    1. 32 bit Access or 64 bit Access?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2013-07-09T10:39:01+00:00

    Hi Gina,

    I have the following references loaded:

    • Visual Basic For Applications
    • Microsoft Access 15.0 Object Library
    • OLE Automation
    • Microsoft Office Access database engine Object Library
    • Microsoft Excel 15.0 Object Library

    Although I do make references to DAO objects, I don't explicitly have the DAO Library Object reference set because:

    1.  Each time I try it to set the reference, it gives me the following error (message box <!>):  Name conflicts with existing module, project, or object library.

    2.  When I compile my code, I don't get an error regarding a missing reference.

    I tried running the "Fix It for me" here (http://support.microsoft.com/kb/2019235) for Windows 7, but that didn't seem to work.

    I'm running Windows 7 64bit, with Office 2013 Pro Plus 32 bit (upgraded from Office 2010 Pro Plus 32bit).

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2013-07-03T04:11:43+00:00

    What References do you have set?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2013-07-03T03:24:28+00:00

    Thank you olb49.  I like the new 2013 updates to the look and feel that 2013 brings, but not nearly as much as I like being able to develop in Access on a platform that doesn't crash.

    Hi Ben,

    I've tried decompiling (following Tim and David's steps here http://stackoverflow.com/questions/3266542/ms-access-how-to-decompile-and-recompile) but the behaviour still persists.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2013-06-26T18:53:55+00:00

    Was this answer helpful?

    0 comments No comments