Access 2007 Stops Working - Restarts

Humm.  I really hate to suggest this, but ... how about uninstalling Office and reinstalling ... since you have done all the usual tricks.  btw ... how did you Decompile ?

Also ... does this only happen on Forms ?

mx

So far it's only happening on forms. I managed to get a form to save by copying an existing form and just changing its recordsource and so forth. Not ideal, but I'm kind of under a time constaint. I guess I could uninstall/reinstall -- would hate to have to re-update everything.. that's always a drag...
I wrote a batch file to decompile -- not sure it even decompiled... I do it all the time in 2003 -- but 2007 is different...

"but 2007 is different..."
Well ... not really.  Try this - attached. Just be sure to use the correct folder paths for Office / A2007.

mx
aaQicPostDecompile.txt

That's funny -- I found that somewhere on the net and used the exact syntax and of course followed all the recommended steps... This is kuckoo. I say it's different because in 2003 the decompile used to open the app when done... path is right or both the msaccess.exe and my app. Good suggestion though....

meant "path is right  for" ... typing too fast...

So, after Decompile in A2007, Access doesn't open ?

mx

Yes... I copied a batch file I used for 2003 apps -- changed nothing except the path to the app...

I did -- exactly... sorry if I didn't make that clear :)

I found the problem: one of the subforms on a form was corrupt. Unfortunately, the form I designated as the Form Template within the Access options was the form which contained the bad subform. While the form was fine to open and enter data into --- when I tried to add a new form I'd get the following message: Microsoft Access has stopped working and must restart... Even after I created a new db and imported everything back in, compacted & repaired, etc. Was at my wits end.... I was able to copy existing reports and change them --- but could not add a new one. I figured the difference was the Form Template.... Aha! So, I once again created a new db, pulled all but the main form and subforms into it -- and then one by one imported the subforms in --- tried to add a new form --- and when I encountered the problem knew which subform was at issue. I wanted post this so if it happens to anyone else --- try this. I would like to assign the points to Mx because of the assistance.

See my final comment for the actual solution.

Thank you for the feedback on the solution ... very cool.

mx