Results 1 to 5 of 5

Thread: DB Size (03)

  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DB Size (03)

    I have a DB whose size is about 500KB. After purging all the records and exiting the DB, the file size is still the same when I view it through Windows Explorer.

    Does anyone know why the file size would not decrease accordingly?

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DB Size (03)

    Have you compacted the database? (Tools | Database Utilities | Compact and Repair Database...)

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DB Size (03)

    Hans,

    Your suggestion worked. I don't understand why the database didn't shrink after I purged the records and exited the DB. Something must be going on: is this a bug in the program?

    Thanks,
    John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DB Size (03)

    No, it's not a bug, it's by design. Like several other database applications, Access doesn't automatically reclaim the space taken up by deleted records and deleted database objects.
    If you wish, you can tick the check box labeled "Compact on Close" in the General tab of Tools | Options... This will cause Access to compact the database each time you close the database (or if there are multiple users, when the last user closes the database). While you're there, also make sure that the check box "Track Name AutoCorrect Info" is clear[ (off).

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DB Size (03)

    Thanks for the explanation.

    John

Posting Permissions

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