Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    compress database (Access 2000)

    My database grows very big. How could i enter a code that compresses the database on exit ? Is it possible to revert to the original zize of the file ?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: compress database (Access 2000)

    You can do that by going into the database you want to compact, then choose Tools/Options/General and tick the Compact on Close.

    I am fairly certain that this is in Access 2000.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: compress database (Access 2000)

    Thank you for the reply. Yes, it works excellent! How could i also compact the back end database, and also in the same time carry out a repair ?

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

    Re: compress database (Access 2000)

    You can set Compact on Close in the backend database. If multiple users have the backend open, it will be compacted when the list user exits it (by closing the frontend).

    A compact is always a compact AND repair, there is no separate repair option.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: compress database (Access 2000)

    Thank you in that case my question is solved so easy ! Thank you

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: compress database (Access 2000)

    >>If multiple users have the backend open, it will be compacted when the list user exits it (by closing the frontend).<<

    I don't think this is true. It didn't happen in tests I ran.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: compress database (Access 2000)

    Oops, you're correct. My memory must be going, for I made the same mistake 6 months ago (see Post: 665,630]) <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: compress database (Access 2000)

    >>My memory must be going<<

    Well, mine isn't a whole lot better. I still had to test it to make sure I remembered correctly!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: compress database (Access 2000)

    Drat! I am just in the process of upgrading a major app from A97 to A2003. When I saw this post I thought it was going to provide a really cool additional benefit of the upgrade. Now you burst that balloon. Oh well -- easy come, easy go.
    <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

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