Question about the option 'Compact/Repair' database.

[Guest]

Hi all,

I have a small question about the option 'Compact/Repair' from MS Access. It
seems that doesn't work optimum. I have a database with quite a lot of form
and report. At the beginning it work very well( I mean the option
'Compact/Repair') , but after a couple of week of development, the database
increase by size, it contains more form, report and module.( Also the
reference). When I try to run the option 'Compact/Repair', it doesn't seem to
work.

Strange is when i try to export all the objects to a new create database and
then run the option 'Compact/Repair' database for the new database then it
works very well. Any idea?

Best regards,

Pat

 

[Allen Browne]

Firstly, make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General |
Explanation of why:
http://allenbrowne.com/bug-03.html

It also might help to decompile the database, by entering something like
this at the command prompt while Access is not running. It is all one line,
and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

It still will not compact as tightly as a new database and importing
everything, and this issue is worse if you use the Access 2002 format
database:
Database bloat is not stopped by compacting database with Access 2002
format
at:
http://support.microsoft.com/kb/810415/en-us

These issues should cease once development is complete, and you are not
constantly modifying the objects in the database.