What I need to do is copy cells from the Table and place them into an Excel spreadsheet. The workaround I found was to copy the entire Table (rather than just the rows or cells) - and paste this to an Excel sheet. This isn't the best solution for me as every cell is copied when I only want a few, but it works for now.
The original problem still exists though; copying cells containing the Yes/No tick boxes causes the program to crash.
I agree it's probably a system or component problem. How are your programming and/or Excel skills? Are you expecting to do this operation often? Here are a couple of things you might try:
1. Create a link from Excel into the Access table. Then you won't have to paste the data and in the query, pivot table data or linked-table in Excel you can filter out what you want or don't want.
2. Use VBA to open Excel via automation (or open Access via automation from the Excel VBA side) and use the copy-recordset command in Excel to put the data wherever you want it.
3. Use VBA automation as before to loop through a range of cells and insert the values into each cell.
I've been doing a lot of Excel-Access data manipulation in the last few projects. It's amazing the simple things that will cause a crash. Just for the heck of it, you might want to test pasting smaller recordsets or limiting the fields used during the paste operation until you identify the actual records or fields that cause the crash to occur.
I had a couple of projects that crashed during the paste operation due to incompatible field types (such as date fields with non-date entries) as well as null values in fields.
BTW the Office XP suite was not particularly stable for certain features and tended to crash a lot on my projects for no apparent reason. I decided, for those customers who used XP, to simply workaround the sensitive features (as you have found out).