View Full Version : My Database swells!.... i'm a newbie please help!

12-26-2004, 06:10 PM
MERRY CHRISTMAS and a HAPPY NEW YEAR to all Coders!!!!

Here's the sitch:
I'm tryin to design a internal messaging system for a group of six ppl. I'm trying to use a MS Access database and ASP Coding to do the storing of the info.
I'm using the "memo" field in access to store the actual message the user writes. But the thing is the database just suddenly SWELLS in size like from 300kb to 5mb :eek: after a few messages are put in. When i delete the messages, the database doesn't shrink.... :confused: I have to delete the database and upload a backed up one. Whats the reason for this and is there another way I could try to implement this messaging system using ASP?

All help will b greatly appreciated :thumbsup:

12-26-2004, 09:23 PM
You need to compact and repair your database, http://www.asp101.com/tips/index.asp?id=97