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 -Compact and Repair the database (no improvement)Uninstalled Office 2010 and re-installed and updated (no improvement)Checked previous dbs known to be free of the problem (no improvement)Installed update 2553385 as recommended by Microsoft (no improvement) The crash always leaves the .laccdb open which stops re-opening the db without first removing the file using Task Manager. I do a lot of work on the db in my retirement, for my personal use (Garden related application) and it is a main hobby which keeps me sane and brain cells occupied. Has anyone got a solution for this problem? I would really appreciate any assistance. Dave Eyley

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? ServusKarlAccess NewsAccess DevCon

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

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" ServusKarlAccess NewsAccess DevCon

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

Hi Dave, If you can narrow it down to one or a few problematic forms, then you have at least 3 options: replace the form from an old copy recreate the form, you can copy the text code over, usually also the non-complex controls 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 'exportApplication.SaveAsText acForm, "MyForm", "c:\MyForm.txt" 'import Application.LoadFromText acForm, "MyForm", "c:\MyForm.txt" ServusKarlAccess NewsAccess DevCon

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

17 Replies

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

Forum Discussion

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

17 Replies

Resources