Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DB Compacting (97)

    All,

    We are trying to compact the db that our code is running in. This is easy once you move to 2000 onwards. But in our friendly 97 version we can not seem to come up with a solution.

    The DBEngine command requires a source and destination, but this can not work as we have the db open, running the code.
    Th Docmd. RunCommand accmdcompact optioin opens a file dialog to search for the file you wish to compact.

    Please help. This is needed as we are using temp tables and they tend to blow the db size out if you don't compact.

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DB Compacting (97)

    Hi Cindy...

    I'll be waiting anxiously for one of the Woody's Gurus to answer this question... I have been working with Access 97 for more than a few years now and I remember back when I started using it trying and trying to compact programmatically... I couldn't get anything to work... I asked here too, I'm sure of it... It'll be great when we upgrade to 2000 or 2002... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Wish I could help you... Good luck!

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

    Re: DB Compacting (97)

    The Access Web has an two different solutions you can use:
    Access 97 Compactor Addin works entirely within Acccess.
    VB5 Compact Database utility (Access 97) is a stand-alone application.

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

    Re: DB Compacting (97)

    Essentially, you can't. The code functionality doesn't extend to the currently open database, only to other databases, which includes the linked back end. If you want to do this from within the database, you'll have to use a tool like those Hans posted links for. And for your information, you still can't do it from code in the later versions from within the current database, although you can do it from the menubar with the database open in 97 forward.
    Charlotte

Posting Permissions

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