Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Red face Unanswered: Access application mysteriously shrank

    Have an Access database application that grew to 49 MB (with basic testing data). App ran fine, closed it one day and the latest version had shrank to 8.8 MB.

    App appears to have all the same functions/features and data. Runs fine and everything. What happened to the other 41 MB? Which version do I continue to work on?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Is the compact on close option selected? Or would anyone have manually compacted it? Or would\ could anyone have written something to programatically compact it?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Mar 2009
    Posts
    2
    "compact on close" is not selected. Wait, though, I was working on the client's computer--could their IT people have configured that machine's resident version of MS Access to "compact on close"? That's a "current database" application option, but is it governed by the MS Access settings of the computer?

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    No, it is specific to the database. Note that it compacting is not a problem at all. The fact that you appear to be saying that there is no reason why it should have is the worry!
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If you have a verions still that is 49MB you could try taking a copy, compacting and repairing it and see if it goes down to 8.8Mb or thereabouts. If so, I'd assume that it was simply compacted "somehow" and use the smaller version. Keep a backup of the 49MB one though
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    If its running on a clients computer, then is it possible that 'their' network trolls may have compacted the MDB as part of 'their' normal processes.
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Ultimately, this doesn't happen unless compacted.
    Whether or not someone or something deleted anything also is moot since they could have done that without compacting.

    I'm giving the database the pootle seal of approval and reckon you can keep working with it **



    ** CYA Disclaimer - the pootle seal of approval confers no rights or warranties and you are on your own if it turns out to be worthless.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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