Strangely large .mdb file size

[inso18]

Hi All.

I don't know if this is normal, but each time I add a bit of code to my access projet, the size increases dramatically. The database is with a few tables and about 8000 records all together, and a reasonable amount of code. Last time I've worked on it, it was 80MB size. Today I've added a few pages of code, and it's already 98MB of size?

Is this proper?

 

[traingamer]

Use the 'Compact and repair' to reclaim the space. Did you compile the code multiple times?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[inso18]

I compiled the code multiply times, yes, but in access2000 file version the size wasn't getting so much bigger. So you say it's a natural thing in access2002-2003 files?

 

[RuralGuy]

Here's a link you might find useful:

http://www.granite.ab.ca/access/decompile.htm

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit