Compact & Repair MDB problem with multi-core CPU

Sadly I do not have a solution for you, but I can tell you that I run Access on a multi-core PC and have never experience such an issue.

Are your installations up-to-date (OS, MS Office/Access)?

What about your PC's BIOS?

It is interesting however that changing the affinity would stop the issue?!

Have you tried creating a new blank db, importing all your database objects and trying again just to see?

I agree with DJSteele and Daniel.  I have not seen the problem on multi-cpu boxes and Access only uses 1 processor.

You problem more likely is from the files size.  It is time to move to at least SQL Server Express.  Though there are many things you can do to make Access and SQL work better, you can often get away with NO changes at all to your coding with your data moved to SQL and the using Linked tables.

If I remember correctly, since Access 2003 there is a 2GB MDB file size limit.  I have compacted & repaired larger Access databases on WinXP without any problems.

As I stated, if i set the affinity to a single CPU the compact & repair works perfectly.

Thanks,

BwilliamsSFR

Everything is up to date, it's a new PC.  I have not tried importing into a blank DB and then trying the compact & repair.  Good suggestion, I will try it this afternoon.

Thanks,

BWilliamsSFR

The problem is repeatable.  I have compressed & repaired larger Access database successfully on my XP box in the past.  If I compress & repair the exact same file on WinXP, no problem (same version of Access).

I agree it's time to move to SQL.  It's in the works, but for now I have to deal with the existing MDB backend database.

Thanks,

BwilliamsSFR

Not sure how you managed to get your MDB to 1.21 Gb, given there's a 1 Gb size limit. I think that may be the issue here, not that you're using a multi-core CPU. I don't believe Access is multi-threaded, so it only uses a single processor.

Good point.  Everything is up-to-date.

Thanks,

BWilliamsSFR