Access application crash now access wont open

Try this procedure:


But first, if you have not already:
Open the VBA Editor and from the menu ...Tools>>References ....
If you see any listed as **Missing: <reference name>, including the asterisks and the word Missing, the
you need to fix that first.

Then, follow this procedure:

****
0) **Backup your MDB BEFORE running this procedure**
****
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
Close the mdb after the Compact & Repair.
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Close the mdb.
6) Open the mdb:
    a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
    b) From the VBA Editor Menu at the top of the window:
       >>Debug>>Compile
        Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

7) Close the mdb
8) Compact and Repair one more time.

*** Executing the DeCompile **EXAMPLE**:
Here is an **example** of the command line syntax  (be SURE to adjust your path and file name accordingly) before executing the decompile:

Run this from Start>>Run, enter the following command line - **all on one line** - it may appear like two lines here in the post:
Also, the double quotes are required.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2003Clients\YourMdbNameHERE.mdb"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

AND ...
Once you get familiar with the Decompile idea (and ALWAYS make a BACKUP first!) ... you can add both Decompile and Compact/Repair to the Right Click menus in Windows Explorer, which I use multiple times daily:

Getting the Decompile and Compact context menu options
http://access.mvps.org/access/modules/mdl0039.htm

mx

mx

You might want to post your "Recovery" link too...

What happens is the access application opens "splash screen displays and goes away and microsoft access shows in the taskbar" but it doesnt maximize. When I click on it nothing happens. I tried the decompile option which didnt do anything.

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /decompile "C:\projects\NCTS.mdb"

Holding down shift key doesnt work either.

Can you upload the db?

mx

New-Microsoft-Office-Access-2007.accdb

I have tried installing office 2007, this does the same thing, Displays splash but remains unusable in the taskbar.

I cannot open msaccess from the start menu either.

I have the db ... seems to be nothing but tables ?

mx

Actually it doesnt matter what DB I try to open, access doesnt open it. Even a new DB by clicking START > ALL PROGRAMS > MICROSOFT OFFICE > Microsoft Office Access 2007.

This opens, shows the splash screen then is in the taskbar but when clicked nothing happens.

Well, that's a completely different story. And you have already reinstalled.

wow.  Try uninstalling Office 2010, reboot, reinstall, reboot ... and see what happens.  If no luck, I would be calling Microsoft Tech Support.

mx

Have you rebooted your PC since this problem? I'm sure you have, but if not please give that a try...

Yes, reinstalled and rebooted using 2003,2007,2010.

Two words:  Call Microsoft.  Something is terribly wrong ...

mx

I will format and reinstall before I call microsoft....Is there any other troubleshooting options?

not that I can think of in this case ... win os reinstall ...

Possible bad memory chips ?



mx

...or a virus...

And finally, Evil Forces From Outer Space:


Capture1.gif

HOLY CRAP!!!!!!  THANK YOU SO MUCH.....

LOL ...

@mx
Been there done that.  I have one popup form that I have coded a height and width for OnOpen because it kept getting 'smashed'. I've seen it happen with Solidworks too
<Grin>

This is on a winxp laptop where the vga out goes to a monitor that sits out in an open office and displays realtime statistics and the main laptop screen is used for development. Weird issue....but thank you so much. I had already started a reinstall on a spare drive with the hopes of the main drive one day working again.....I tip my hat to your knowledge......

Yeah ... I really should have thought of that.  But it seems odd that after the reinstall of office you did that would still be in effect!

mx

Same results after reinstalling 2010 then 2007 then 2003

Anyways Im making it standard procedure to hardcode a height and width for OnOpen for all forms going forward....

It's more of a Windows thing than anything else.
Windows remembers the size an app had when you last closed it.
If for some reason it thinks that was Zero, well there you have it.
And it remembers it for the Access application class--not a particular version.

I don't think you need to be paranoid about EVERY form.
But given that you have encountered it, hard-coding the first form in the app may be prudent
My problem form was a pop-up form.
Things had a habit of being unhappy if the dual monitor setup wasn't monitor #1 on the left and #2 on the right.
If I re-arranged them otherwise in the display applet, it happened more often.
Coding it fixed its wagon but good, though