QUESTION
———
When opening a Microsoft Access database file, Access crashes with a pop up message stating:
Screen shot window. ——————————————————————–
Microsoft Access
——————————————————————–
Microsoft Access has stopped working
Windows is checking for a solution to the problem…
Microsoft Publisher has stopped working. Before you try any of the resolutions in this article, it's important to make sure that Office is fully up-to-date. If you still get 'stopped working' errors after installing Office updates, choose Most Office apps or Outlook and follow the troubleshooting options in the order they are presented. Disable Add-ins in Safe Mode. Some incompatible add-ins may cause Word stopped working error. Watch Part 2 With Good Audio Quality.Link:- office has stopped working Method 1 - This stop working solution is right clic.
[Cancel]——————————————————————–
Finally resulting in the following message:
Renamer 5 1 0 – rename files in batches. —————————————————————————————
Microsoft Access
—————————————————————————————
Microsoft Access has stopped working
A problem caused the program to stop working correctly. Premier film editing. How to get editing software for free.
Windows will close the program and notify you if a solution is available.
Sometimes you can get the file to open successfully by holding down your shift key while opening the file, but after a minute or two, or if you attempt to open any forms, etc… the same two messages will pop up and close Access on you.
ANSWER
———
The final answer that worked for us was referenced in this post:
http://answers.microsoft.com/en-us/office/forum/office_2010-access/access-2010-sp1-you-receive-random-crashes-in/d2bf6175-075a-4a12-a2b1-f55d40af271b
And a patch from Microsoft can be downloaded here:
—
KB Article Number(s): 2596585 ; Platform: i386
http://hotfixv4.microsoft.com/Microsoft%20Access%202010/sp2/office2010kb2596585fullfilex86glb/14.0000.6112.5000/free/439894_intl_i386_zip.exe
—
KB Article Number(s): 2596585 ; Platform: x64
http://hotfixv4.microsoft.com/Microsoft%20Access%202010/sp2/office2010kb2596585fullfilex64glb/14.0000.6112.5000/free/439895_intl_x64_zip.exe
It appears to be a known issue with Microsoft having to do with Microsoft Access 2010 SP1.
Much of the issues reported seem to hover around 64bit versions, but that was not the case with us – we found this issue running 32bit Microsoft Access on Windows 7 Professional 32bit.
The fix it turns out was relatively straight-forward and worked for us in EVERY instance – simply open your corrupted database from the command prompt along with the /decompile switch (see EXAMPLES), then close Access, and re-open your database normally. All should be well.
(If running Windows 7, simply running Microsoft Access from the Start Search field with the /decompile switch works as well: Click Start, type msaccess.exe /decompile)
NOTE: In our experience, many times, it will take opening the database in this manner (database path /decompile) a few times before it starts working again…
NOTE2: You must also ensure the options are set to Compact and Repair on close, if this is not set, the /decompile appears to have NO effect.
———
Another suggestion was:
Open the Microsoft Access application alone, not opening a file.
File, Options, Add-ins
Click the Go… button at the bottom of the window next to the Manage: COM Add-ins drop down list
Un-check the check boxes next to the add-ins you can stand to live without and click OK
———
There appears to be a hotfix available for this issue as well now:
http://support.microsoft.com/kb/2596585
http://support.microsoft.com/kb/2625046
EXAMPLES
———
Open a command prompt (Start button, All Programs, Accessories, Command Prompt)
Type the full path to the database and follow it with /decompile and hit enter.
/decompile
EXAMPLE: 'C:UsersMeDocumentsMyCoMyTeamSystemsMyDB.accdb' /decompile
My Microsoft Office Starter Stopped Working
———
Note: You can also open Access itself in /decompile mode and then the next database you open will be decompiled.
EXAMPLE:
'C:Program FilesMicrosoft OfficeOffice14MSAccess.exe' /decompile
APPLIES TO / KEY WORDS
———
Microsoft Access
Crash
Hang
Crashed
Corrupt
Corrupted
Corruption
REF
———
http://answers.microsoft.com/en-us/office/forum/office_2010-access/access-2010-sp1-you-receive-random-crashes-in/d2bf6175-075a-4a12-a2b1-f55d40af271b
My Microsoft Office Stopped Working
—
http://www.anysitesupport.com/error-microsoft-access-has-stopped-working/
http://anySiteHosting.com
