Memory optimization please help 2

[BotCow]

Data is supposed to be small right? Well, even after I changed field sizes to as small as I could get them, my Access file is still 102mb for one 3000 entry table with 11 fields, and two really small tables with about 10 entries each. Then I have 11 reports with an 18kb graphic on each one, 11 queries, and 11 macros (eleven's just my number today). So it's not a large database at all. Why is it so big? And how do I shrink it, this thing needs to be portable sometimes.

 

[simco]

Did you compact your database? If no, do so (go to Tools/Database Utilities/Compact Database).

 

[Maquis]

Have you compacted the database lately. Access tends to balloon up in size very quickly and should be compacted on a regular basis.

Goto Tools ---> Database Utilities ---> Compact Database.

Maq
<insert witty signature here>