Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts
    When I run an append query that appends a table with data from an Excel spreadsheet, my database gets very bloated. So I normally try to run the compact and repair soon after and that reduces it back to it's original size. However, this one database refuses to shrink back to the size it should be. It is currently 237 MB. It does create a backup when I run the compact and repair and the backup is just 4.5MB probably the size it should be compacted to.

    Is there a setting in the database that I've missed, or is there something else I'm doing wrong?

    Thanks,
    Eric

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Try creating a new database and import all the objects from the one you are having a problem with.

    If the new database works OK then it was just a problem with the old database container. Happens Sometimes.

Posting Permissions

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