About Compacting

[Noel]

Hi. Ive just looked at the Access 2002 help files on
Compacting and Repairing and what it says doesnt work for
me. If I go through the Compact and Repair process for a
mdb thats not open and chose to save the compacted file
under a different name, all works OK - it compacts down
to about 15Mb. If I Compact an mdb that I have open and
that is not being used by any other user (its a backup
copy), the process seems to run but the mdb remains at
its previous size. Also the same happens if I set that
mdb to Compact and Repair on close. Am I doing something
wrong? Thanks, Noel

 

[Guest]

-----Original Message-----
Hi. Ive just looked at the Access 2002 help files on
Compacting and Repairing and what it says doesnt work for
me. If I go through the Compact and Repair process for a
mdb thats not open and chose to save the compacted file
under a different name, all works OK - it compacts down
to about 15Mb. If I Compact an mdb that I have open and
that is not being used by any other user (its a backup
copy), the process seems to run but the mdb remains at
its previous size. Also the same happens if I set that
mdb to Compact and Repair on close. Am I doing something
wrong? Thanks, Noel
.

Only a suggestion. This may not be your problem but I
have experienced similar problems before.
1st - open any module in you database and then on the
menu bar select Debug, then Compile. Access will try to
compile your database code. If an error is found it will
not compile and will take you to the error found.
Perform this task repeatedly until you have fixed all
errors, then try to compact and repair.
2nd - If this does not work, then your Access database
container is corrupted. Create a new Access database,
and then import all your objects from the original mdb
into the new mdb. You should be able to compact and
repair the new mdb without problems. Delete to original
mdb and rename the new mdb to you original mdb name.

 

[Noel]

Hi. Thanks for this. Im hoping that this is not my
problem. After all, I can Compact and Repair when I dont
have the mdb open. Surely that indicates that the mdb is
not corrupted? Ill wait a little while to see if others
have some alternative thought before I go down the route
you suggest. Thanks again, Noel