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: Newest
  1. Anonymous
    2014-02-05T03:34:03+00:00

    Is this a split database?  Have you tried refreshing the links?  The Form you are opening, does it have code behind it?  Can you copy/paste that code here?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2014-02-05T03:11:47+00:00

    You are not using Access 365 for this database, so a reinstallation of Office 365 will not make any difference to the database.

     

    Is there a Main Menu/Switchboard that opens when the database is first opened?  Is there any code behind that Form.  If so, please copy/paste it here.  Another thought, the database is in a Trusted Location correct?

    No, there are no Forms that open or a switchboard.

    The database is in a trusted folder.

    Little bit more information for you - If I attempt to open the form from All Access Objects, firstly by right click, select Design View, then change to Data Sheet View I get the same error.

    It is intended that a user will open the forms from a selection made in a combo box and this is how I first found the error through using the combo box.

    Everything was fine before I requested a change be made to the forms to allow for a multi-choice selection in the combo box. It was a check box, but when it was changed to a combo box that's when the problems started.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-02-05T02:40:44+00:00

    You are not using Access 365 for this database, so a reinstallation of Office 365 will not make any difference to the database.

    Is there a Main Menu/Switchboard that opens when the database is first opened?  Is there any code behind that Form.  If so, please copy/paste it here.  Another thought, the database is in a Trusted Location correct?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2014-02-05T01:59:04+00:00

    Scott,

     

    Make a copy of the file and uncheck it in the copy, see if everything still works.  If it does then that was the issue.

     

    If there was additional lines of code after...

     

    Option Compare Database

    Option Explicit

    ...you cannot make the change to Has Module = No because it does have one.

    Sorry Gina,

    The issue is still there after ticking off Microsoft Office 15.0 Object Library.

    I also tried the Decompile on the run command and Compact and Repair mentioned earlier in this forum.

    Just run a repair from Programs and Features while on line. It seemed more like a re-installation of Office 365. Didn't change anything.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2014-02-05T01:37:03+00:00

    Scott,

    Make a copy of the file and uncheck it in the copy, see if everything still works.  If it does then that was the issue.

    If there was additional lines of code after...

    Option Compare Database

    Option Explicit

    ...you cannot make the change to Has Module = No because it does have one.

    Was this answer helpful?

    0 comments No comments