DB size

[bluenose76]

Hi,

A general curiosity really,

My current DB I am working on has 4 tables, 5 queries, 3 forms and 4 modules.

At spent I have less than ten records stored, with only 15 columns per record.

My curiosity is to understand why my DB is close to 6MB in size when there is little to no data within it?

Has anyone else come across this? And is there a way to reduce this?

Thank you

Regards,
Arran

 

[llkhoutx]

Max MDB size is 2G. MDBs "bloat" and become inordinately large, that's just Access. There's a lot of reasons for same but it's very common. Doing a repair and compact of your MDB will become most always reduce it's size, unless you have an extraordinarily large tables. When using DAO/ADO recordsets, always close them them when they're no longer needed.

 

[llkhoutx]

5, no trump! lol

 

[bluenose76]

Pat

thank you,

Top tip and I will try this from now on.

Regards
Arran

Every time you do something like create a query or a form or any other object and add/delete fields, etc, Access needs to acquire workspace to use and it doesn't free up that workspace or even reuse it. The only way to clean house so to speak is to compact the database.

When I am actively developing a database, I tend to leave the Compact on Close property set to true because databases can grow at an alarming rate while you are developing. Then when I move the app into production for the users to use, I turn the feature off because the users can't do anything but work with data. They are not allowed to change any objects and so the database doesn't bloat under production use. For the BE, I schedule a weekly job to compact it. Usually the BE just grows gradually as data is added. However, if you are using temp tables, you will run into bloating issues and will need to run the compact and repair utility more frequently.