microsoft access 2007 crashes in design view

everytime I go into design view of a form - my access program crashes delivering the below error.  does anyone knows what could be causing the program crash

Problem signature:
  Problem Event Name:      APPCRASH
  Application Name:      MSACCESS.EXE
  Application Version:      12.0.6606.1000
  Application Timestamp:      4e27ab6b
  Fault Module Name:      MSACCESS.EXE
  Fault Module Version:      12.0.6606.1000
  Fault Module Timestamp:      4e27ab6b
  Exception Code:      c0000005
  Exception Offset:      000f3a22
  OS Version:      6.1.7601.2.1.0.256.48
  Locale ID:      1033

Additional information about the problem:
  LCID:      1033
  Brand:      Office12Crash
  skulcid:      1033

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt
tawondaAsked:
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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Many things can cause Access to crash. The first thing you should do is perform a bit of maintenance.

First, make a backup of your database.

Now do this:

1. Compact the database.

2. Decompile the database. To do this, create a Shortcut with this as the target:

"full path to msaccess.exe" "full path to your db" /decompile

Then "run" the shortcut, and Access will decompile your db

3. Now Compile the database. To do this, open the VBA Editor and click Debug - Compile. Fix any errors you might find, and continue doing this until the Compile menu item is no longer enabled.

4. Compact the database again

From there you might also consider moving everything into a new, blank database container. To do that, create a new database, then use the External Data - Import ribbon to move everything from the old db to the new one.

Finally, be sure that your Office and Windows installations are fully up to date.
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
Tony BarkdullTier 2 SupportCommented:
Make sure your MS Access is up-to-date with Service Packs and KB's
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.