Results 1 to 3 of 3

Thread: DB too large

  1. #1
    Join Date
    May 2003
    Posts
    70

    Unanswered: DB too large

    Hi,

    I have an application which is written in Access. It was always around 5MB (the mdb file, the mde around 3.5). Today, I just made a simple little change (no new object, just small code change) and the database grew to 21MB.
    Any Ideas why?
    I can't have it that bid.

    Thanks,

  2. #2
    Join Date
    Nov 2003
    Posts
    14

    Post

    Suspect it might be b/c you've deleted a lot of records then recreated them. When you delete records, they aren't actually deleted: they're just flagged for deletion. To properly delete them, you have to Compact & Repair the database (Tools > Database Utilities).

    Good luck.
    Bruce.

  3. #3
    Join Date
    May 2003
    Posts
    70
    The application file doesn't have tables, just table links.
    I did compact and repair, didn't help.

Posting Permissions

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