Forum Discussion

Dave_Eyley's avatar
Dave_Eyley
Copper Contributor
Sep 07, 2022

MS Access 2010 crasing on moving from Form Open to Form Design

Hi all, I have Office 2010 and use Access for hobby use. Lately, the database is crashing when I click on the screen header and select Design View from a Form View.  I have attempted to  - Compac...
2010
Karl_Donaubauer's avatar
Karl_Donaubauer
MVP
Sep 08, 2022

Hi,

 

To clarify the scope of the problem:

 

1. Does the crash happen only with a particular form in your db?

2. With all forms in this db?

3. With a new form in a newly created db?

 

Servus
Karl
Access News
Access DevCon

Dave_Eyley's avatar
Dave_Eyley
Copper Contributor
Sep 08, 2022
Hi Karl,

It happens, most times, When I'm changing from View to Design mode with any form in the db but not every time. It's a bit like Russian Roulette. You just never know...

The db was first started around 2013 and has been reliable until recently. A suggestion that an Office or Windows update might the cause was made on the Access World Forum. I followed an instruction to remove an update but that had no effect.

I would be grateful for any help.

Dave

  • Dave_Eyley's avatar
    Dave_Eyley
    Copper Contributor
    Sep 08, 2022
    Hi Karl,

    I did create a new db and imported all the objects into it. The same result.
    The database isn't compiled so I did a few Compact and Repair attempts with no effect.
    I created a new db and a new form and haven't had the problem so far.

    Since your last reply I have been substituting forms from previous aschives and got back to 2019 before the problem went away. Which is odd considering the bug only started a few days ago.

    Now, I'm going to return to the troublesome form and start removing objects to if I can identify the nasty bit.
    When, and if, I find something I will let you know.

    Thanks for you help and suggestions thus far.

    Dave

    • Karl_Donaubauer's avatar
      Karl_Donaubauer
      MVP
      Sep 08, 2022

      Hi Dave,

       

      If you can narrow it down to one or a few problematic forms, then you have at least 3 options:

       

      1. replace the form from an old copy
      2. recreate the form, you can copy the text code over, usually also the non-complex controls
      3. If 1+2 are too laborous, you can try to export the form as text, then delete it, compact the db and reimport the form. This procedure often removes corruptions from forms (or other Access objects). It can be done from the immediate window with

      'export
      Application.SaveAsText acForm, "MyForm", "c:\MyForm.txt"

      'import

      Application.LoadFromText acForm, "MyForm", "c:\MyForm.txt"

       

      Servus
      Karl
      Access News
      Access DevCon

      • Dave_Eyley's avatar
        Dave_Eyley
        Copper Contributor
        Sep 08, 2022
        Had a problem using the Immediate window. I copied your export command to the window and changed the MyForm:

        Application.SaveAsText acForm, "MainOptions", "c:\MyForm.txt"

        I got the error message:

        Our Garden Database can't open the file "c:\MyForm.txt"

        The forms was open in VB View to access the Immediate window.
        I copied and pasted your command and just altered the Form name
        Where am I going wrong?

        Dave
  • Karl_Donaubauer's avatar
    Karl_Donaubauer
    MVP
    Sep 08, 2022

    Hi Dave,

     

    How about question No 3?

    With some testing of a new db you might be able to determine if it is a system problem or a corruption in the particular db.

     

    Did you already try the usual things with corrupt dbs?

    a) create a new accdb and import all objects from the old db

    and/or

    b) the decompile command line switch, e.g. with a shortcut and a target path like

    "c:\AccessPath\msaccess.exe" /decompile "c:\YourApplicationPath\Your.accdb"

     

    Servus
    Karl
    Access News
    Access DevCon

Resources