How to compact/compressing mdb file

[Jerry Maiapu]

Can anyone tell me how I can really compress/compact my 17MB mdb file.
A link to any third party MS Access 2003 compactor would do.
I have about 3 tables
1st table( 20 entries)
2nd // (15 records)
3rd // ( 3 records)

I have about 5 queries and 10 forms

But I don't see any reason why my db file is this big.

Thanks

[TheSmileyCoder]

Can anyone tell me how I can really compress/compact my 17MB mdb file.
A link to any third party MS Access 2003 compactor would do.
I have about 3 tables
1st table( 20 entries)
2nd // (15 records)
3rd // ( 3 records)

I have about 5 queries and 10 forms

But I don't see any reason why my db file is this big.

Thanks

Have you tried within Access itself to click:
Tools->Database Functions->Compact and Repair?
(Menu names may be different, depending on language settings)

[ahmedtharwat19]

OR You Can Use This Code in Vba

CommandBars("Menu Bar").Controls ("Tools") & _
.Controls("Database utilities") & _
.Controls("Compact and repair database...").accDoDefaultAction

Best Regards ,

Ahmed Tharwat(Medo)

[ahmedtharwat19]

But I don't see any reason why my db file is this big.

The Reason : Every Time You Edit The mdb file This Encrease The mdb file size , So You Should Run The Compact & Repair The Data base After You Finish from Edit mdb.

Best Regards ,

Ahmed Tharwat(Medo)

[missinglinq]

This procedure has been repeatedly been given as the cause of corruption, so you should always back up your database before running C & R!

For this reason, IMHO, the Compact on Close option should never be used!

Linq ;0)>

[Jerry Maiapu]

I am sorry I would have told you already. I used C&Repair tool in access many times but still no changes. Are there other ways of compact/compressing apart from C&R tool or removing images from forms. (FYI: I have only one image in the start up form).

Thanks

[OldBirdman]

You could try the "Jet Compact Utility" by Microsoft. This is a free download from MS and may do things the normal Compact & Repair cannot do.

http://office.microsoft.com/en-us/access-help/repairing-damaged-access-databases-with-the-jet-compact-utility-HA001034570.aspx

[missinglinq]

First off, this isn't really a "big" database!

Secondly, if the image is actually stored in the database, rather than simply being linked to, and this is pre-Access 2007, this is probably your problem.

Linq ;0)>

[Jerry Maiapu]

No it's a link image so I'll try and check the link.

Thanks

[Jerry Maiapu]

OldBirdman,the problem seem to persist even now would you you tell me how to use the tool you advised me to download (POST#70? I downloaded it. The untility tool requires us to load two mdb files which two mdb files is it referring to?
Thanks

If anyone can help do so.
Cheers..

[Jerry Maiapu]

OldBirdman,the problem seem to persist even now would you you tell me how to use the tool you advised me to download (POST#70? I downloaded it. The utility tool requires us to load two mdb files. Compact From (Source) and Compact into (Destination).W hich two mdb files is it referring to?
Thanks

If anyone can help do so.
Cheers..

[OldBirdman]

This utility creates a new file, leaving the old one unchanged. Therefore, you do not need to backup the file before attempting to compact.
Source is the name of your database.
Destination is the name you want for the compacted database.
After you test the compacted version, you can delete your original copy(Source) and rename the new(Destination ) to the original name.
Although this is not a 'third party' compactor, I have found that it compacts to the smallest size possible, as compared with Access 'Compact and Repair Database...' Tool

[Jerry Maiapu]

The database after compacting has now increased somehow to 18,996 kb which is about 19meg. Really pissing me off. Is there any other way to compact the mdb file?
Thanks

[OldBirdman]

The only other way I know of is to start with a blank database and import the objects from your current database.
If you do this in several steps, importing only a few objects at a time, you should be able to figure out which object(s) are causing the excessive size.

[Jerry Maiapu]

Thanks I'll do that and come to you later