Database Bloat?!

[larrydb]

I have an MS Access 2000 Database that is growing by 100 MB a month. It does not use any DAO. It was originally 120 MB and now it's up to 700 MB. It is reasonably relational and normalized. The main table is 32,000 records with other tables at 15,000, 10,000, 10000, and a few thousand or less for the other 17. I can't figure out where the "bloat" is coming from. Any ideas?

 

[gusbrunston]

Hi-
Select Tools, then Database Utilities, then Compact and Repair Database from the menu. My database was four times the size it should be when I was told to do this. I've chosen the option for this compact and repair to be done everytime I log off. Hope this helps.
Regards,
Gus Brunston
An old PICKer
padregus@home.com

 

[Francescina]

Do you use tempory tables? If so then remember that deleting them does not free their occupied space, only compacting does.

 

[larrydb]

Thanks for your reponses- I guess I posted this in the wrong forum. Sorry about that.
I have tried compact and repair four times without any success. It got a little smaller (14 MB) the first time, but there was no change after that.
Any other suggestions?

 

[JoeMiller]

Are you embedding graphics or ole objects in the tables? Do you use lots of backgrounds or pictures on your forms? All these things contribute to bloat. A small picture can take up ten times its normal size when embedded in a access db.

Joe Miller
joe.miller@flotech.net

 

[larrydb]

No graphics, OLE, temp tables, pictures, DAO, etc. Just a database with data.
Any more ideas?

 

[gusbrunston]

Have you made your database a Design Master? Replication will sometimes double the size of your db.
Gus Brunston
An old PICKer
padregus@home.com