I have a database that I use in VB. As records update there is 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?