Access 2007 Stops Working - Restarts

Hi Experts! This problem is maddening... I hope someone has some suggestions... I am developing an application in Access 2007 -- and every time I attempt to create a new Form (I've tried clicking on Form, on Blank Form or Form Design) I get a message that Microsoft Access has stopped working and must restart... I've tried adding and then saving a blank unbound form - still happens, compacting and repairing the db, have creatd a new db and imported everything in twice, have repaired my installation of Office, twice. I have not let the db bloat to more than 2 mb (so far)... I have also decompiled ... I'm out of ideas...

I'm running Access v: 2007 SP2 MSO
This laptop is running Vista 6.0 SP2

Thanks for any help you can give me.... Best, Eileen
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
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...
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"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
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Eileen MurphyIndependent Application DeveloperAuthor Commented:
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....
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
meant "path is right  for" ... typing too fast...
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
So, after Decompile in A2007, Access doesn't open ?

mx
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Yes... I copied a batch file I used for 2003 apps -- changed nothing except the path to the app...
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
ok ....soooo, did you try my Decompile procedure ?

mx
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
I did -- exactly... sorry if I didn't make that clear :)
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Darn ... well ... I'm leaving work now ... back later tonight ... sorry.

One more try ... do you still have your A2003 version?  If so, create a brand new ACCDB in A2007 and import everything from the A2003 mdb ... be sure the A2003 is compiled first.

later ...

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eileen MurphyIndependent Application DeveloperAuthor Commented:
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.
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
See my final comment for the actual solution.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Thank you for the feedback on the solution ... very cool.

mx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.