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

87 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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
  2. 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
  3. 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
  4. Anonymous
    2014-02-05T00:19:18+00:00

    Do you know why...

     

    Microsoft Office 15.0 Object Library

    ...is selected?

    Next, if you look at the Module behind and Form and the only thing there is...

    Option Compare Database

    Option Explicit

    Then you need to look in the Properties windows for *Has Module* and select *No*.  However, I would urge you to make a copy first and make these changes on the copy.

    Gina, being a novice I don't know why Microsoft Office 15.0 Object library is on, would you suggest I take it off?

    The two lines of code were above a line then below the line is Private Sub Form_Load() followed by the rest of the code. Silly me thought they were on their own and didn't serve a function.

    I checked the properties window, Has Module is true, should I still make the change?

    Was this answer helpful?

    0 comments
  5. Anonymous
    2014-02-05T00:07:10+00:00

    Do you know why...

    Microsoft Office 15.0 Object Library

    ...is selected?

    Next, if you look at the Module behind and Form and the only thing there is...

    Option Compare Database

    Option Explicit

    Then you need to look in the Properties windows for *Has Module* and select *No*.  However, I would urge you to make a copy first and make these changes on the copy.

    Was this answer helpful?

    0 comments