Forum Discussion
MS Access 2010 crasing on moving from Form Open to Form Design
Hi Dave,
My example path might not have been the best example. 😉
The root folder of c: by default is forbidden in Windows. Instead use any drive/path you are allowed to use in your system or e.g. the same path as the db with:
Application.SaveAsText acForm, "MainOptions", CurrentProject.Path & "\MainOptions.txt"
Servus
Karl
Access News
Access DevCon
Well, I've checked the text dump and found nothing out of the ordinary. It was rather a long read too.
I've found that the problem is intermittent and less if I steer clear of the top of the form bar when selecting Form View/Form Design etc.
It's strange how the crash occurs when the VBA code isn't active.
I'm going to soldier on for a while and see if anything changes - who knows, there might be an update to cure the problem any day soon, although I won't hold my breath.
Thanks for your help.
Dave
Thankyou.
The last few days Access has been crashing when I go from Design View to Form View.
I have read a lot - but when I did the DISM online it has returned to normal.
For anyone else - this is the page I used.
https://www.windowscentral.com/software-apps/windows-11/how-to-use-dism-to-repair-local-image-on-windows-11Everyone gets caught up with decompiling, compiling, compacting, extracting and reimporting to a blank database. Repair Office etc But when you have done all that and it still happens, then it is not the database. It is the in the Windows install.
So Thank you again. xxx
- Hi Karl,
I kept searching online and found, on the Punch Technology Help Centre, the following Command Line - DISM /Online /Cleanup-Image /RestoreHealth
After I executed the command the problem appears to have resolved. I have been 3 days without a crash.
I remain ever hopeful.
I write that you may find this useful.
Kind Regards
Dave Eyley - Well, even that failed eventually. It looks like I'm stuck with it for a while. I'm still working on the db but hitting the Design View option is like playing Russian Roulette.
Happy Daze...
Dave Eyley - Hi Karl,
This is strange.
I rebuilt the database and when I run it from File Explorer it's fine. I can switch views with impunity.
However, when I create a desktop shortcut and run it from there, the problem returns. Same file, different launch location. A problem with Windows, possibly?
I did upgrade to Windows 11 a while back but reverted back to Windows 10 very quickly. Would that, could that have caused a glitch?
Kind Regards
Dave Eyley - Hi Karl
Used the Rebuild Add-in.
It froze both the original and the rebuild db at two points - both on forms.
Deleted the forms and continued to completion.
Rebuilt database still crashed/closed as before.
I am going to check the two forms that stopped the Rebuilder because I remember copying one from the other and making minor changes to the copied one. Maybe there is a piece of code that is problematical and I missed.
Regards
Dave Eyley Hi,
Instead of doing this for every single object in a db I would recommend you a tool that does this for you: https://team-moeller.de/en/?Add-Ins:TM_Rebuild-Database
Servus
Karl
Access News
Access DevCon- Hi Karl,
It seems I was on the right track but nowhere near a destination 🙂
Can you list the steps for me to accomplish the full text export + delete/compact + text reimport process?
The database is callled - Garden Database.accdb - located in a folder called - C:\Access Files
I would use a temp location of C:\Documents to export the text. So, perhaps, you could show me the correct syntax for each command?
Gratefully yours
Dave Eyley - Hi Karl,
I read up about importing all databse objects into a new, blank db and tried it. It seems to have worked. I'm still going through all of thr database operations but, so far, it's looking promising.
I'd like to thank you for putting me on the right track.
Kind Regards
Dave Eyley (Plymouth - England) Hi Dave,
Just to explain the text export:
With reports it is really sometimes about seeing stored printer setup garbage there and deleting it. With forms, on the other hand, it's hardly ever about reading the text dump. Usually you don't see anything special there and that's good. It's mostly about text export + delete/compact + text reimport to clean up the binary lump in the system table where Access stores these objects.
Servus
Karl
Access News
Access DevCon
