Access keeps crashing

[the boy holty]

I'm trying to make some changes to an access db - adding buttons, tying them to queries - fairly meaty stuff but nothing too strenuous and I have a decent spec laptop, but it must have crashed 20 or 30 times today.
Sometimes it closes down all by itself, sometimes it just hangs and twice its caused my screen to go black and only a forced shut down and restart has got me back up and running.

This is the first time I've had to do any real development work in Access and I'm growing to hate it more and more with every minute that passes.

Does this sound like a hardware issue, a poor installation or is this something in Access that I'm going to have to get used to?

 

[billmeye]

You might have database corruption. If so, make a copy and try decompiling:

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "C:\yourdatabase.accdb" /decompile

If you are using Access 2010, it is Office14, if Access 2007 it is Office12, if Access 2003 it is Office11 and extension mdb

The Compact and Repair the database and then go back in and try re-compilling.

If you have already tried then it must be something with your code. You could remove it all and add it back piece by piece to see what causes the failure.