Access 2010 Compact & Repair drops indexes in descending order. The database is ~700MB and the table affected has 190 columns, 228,000 records and 13 indexes and runs on Windows 7 with 4GB of memory. The same file compacts without incident using Office 2007 on a Window XP machine with 2GB of memory. Strangely it runs OK on a VM running Office 2010 and on my home desktop running Office 2010 on Windows 8.
Can anyone tell me why this is happening after a year of daily compacting? The file grows by about 500KB a day. I am seriously considering downgrading my main office desktop to Office 2007.