Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    Texas, USA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Bloat (Access 2000)

    I Know delating tables forms and reports can cause bloat but what about queries. Does deleteing them and adding cause your small database to become a disk eating monster?

    and is it possible to automatically compress and rebuild or is strictly a manual process?

    Larry

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access Bloat (Access 2000)

    There is an option to automatically compact on close.
    Look in tools...Options..general
    Regards
    John



  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access Bloat (Access 2000)

    Actually, just opening a 2000/2002 database will cause it to grow a little bit - but when you start creating temporary tables, or if you start putting in OLE objects then databases will grow like topsy. As you noted, adding and deleting objects such as tables, queries, forms and reports also will make it grow. The autocompact is one solution, but is only available in 2000 and 2002.
    Wendell

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Bloat (Access 2000)

    John's recommendation about compact on close works great. Just be careful if you have multiple users - if two people are in the database and one closes it, the db will begin to compact and will error because you can't compact a database opened by another user. Also, if you have a front-end and back-end setup, compacting the front-end won't give you as big a benefit as compacting the back-end.
    Just a few things to keep in mind.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access Bloat (Access 2000)

    Actually, if two people are in the same database, the compact on close only works for the last person left standing. There shouldn't be any error when the other user exits first.
    Charlotte

  6. #6
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Bloat (Access 2000)

    Larry,
    Charlotte cleared up bad advice on my part. It does compact correctly on close.

Posting Permissions

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