My environment: business use, connected to a domain. PC = Win7-Pro SP1 64bit, i5-3570 CPU, 8GB RAM, Office2010 Pro V14.0.6125.5000 (32bit) installed.
Are there any updates or hotfixes to fix an Access2010 Compact & Repair problem with multi-core CPU’s?
Problem: when I run a Compact & Repair on an existing MDB database, eight tables are completely deleted (with no error messages). If I set the MSAccess.exe affinity to a single CPU and run the Compact & Repair on a copy of the original MDB file, everything is fine. Original MDB files size = 1.21GB.
Added 1/25/2013: I found a comment on another MS forum that discusses the CPU affinity fixing an Access 2010 problem. That's where I got the clue to give it a try.
Thanks for any suggestions,