MS Access 2007/2010 Compact & Repair not working

[danielgriffin12]

I have a database that I use in VB. As records update theres a lot of useless info in there because access doesn't reuse the same spots. So that information has to be removed. Before I would use compact & repair and access 2000 and it would correct this. It would correctly adjust the file size and remove all the wasted space or whatever happens in Access.


Compact and repair feature in 2007 and 2010 does not fix the file size.. why?

[orange]

What happens when you do a compact and repair?

What exactly does this mean? As records update theres a lot of useless info in there because access doesn't reuse the same spots

More info