Database File Size 1

[MAPetry]

I have a database that was approx 5M. then in one day increased to over 8 meg with no real data increase. now it is up to 13M. I went in a erased some tables and queries in a backup but that made no change in file size. Is this common with access or is there some was to refresh file size?

Thanks for any help.

 

[JerryDennison]

Try compacting the db. If no significant reduction is evident after compacting re-examine the data types being stored. Images stored in the db can dramatically increase db "bloat".

 

[MAPetry]

I will try compacting but I only have one image and that is on the splash screen. Everything else is straight data.

 

[MAPetry]

That worked. It is now down to around 6M. Thank You very much.

 

[THoey]

MAPetry, you don't have this marked for email, but maybe you will see it and understand why it is important to compact periodically. The reason for doing the compacting of the database is that Access doesn't really delete anything when you tell it to. It just marks it as deleted and makes it invisible to you. This is true for everything from data to tables to forms, etc... So, it is an especially good idea if you are in development and changing strategies in mid-stream. Once it is in production, you won't have it as much, unless you are making mass deletes of data.

Just thought I would give you a reason behind the solution... Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[Quehay]

Thanks th3856! I often purge unneeded forms/tables/queries from templates to streamline performance. The db's are set to "Compact on Close" so the objects are removed, but I wondered what occurs with object deletes and whether there was an edit buffer for these like data buffers.