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?
Best Answer
Open that database in 2010, and do this:
Now, close out the database and make a copy of it. Reopen the new database, and Compact it.
If you're still have troubles after that, then there is a good chance that you have troubles with the installation of Access/Office or Windows on your machine. Be sure that you've fully updated Office and Windows, and try again.
If you're still having troubles compacting, then you may need read this MSDN forum thread.