Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Dec 2004
    Location
    Jamaica
    Posts
    592
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Angry My Database swells!.... i'm a newbie please help!

    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 after a few messages are put in. When i delete the messages, the database doesn't shrink.... 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

  • #2
    New Coder
    Join Date
    Aug 2003
    Location
    Shawnee Mission, Kansas
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You need to compact and repair your database, http://www.asp101.com/tips/index.asp?id=97
    John Shepard
    Beyond The Impossible
    -----------------------------
    http://freeasphelp.tech.nu/
    FreeASPHelp by John Shepard
    Sign Up for a free account today!
    100% Free ASPHelp


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •