Page 1 of 2 12 LastLast
Results 1 to 15 of 23

Thread: file size (97)

  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    file size (97)

    I have a database which has been about 24Mb for several years now. Two weeks ago it bloated to 41Mb.

    I tried the usual decompile / compact / repair routine several time but it has resisted returning to the original size. I've examined it and see nothing unusual.

    Are there any tools which can be used to identify the source of the bloat?

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

    Re: file size (97)

    Not really. The other thing you can try is to create a new database and import all the objects from the old one. That eliminates any of the behind the scenes objects that might be causeing problems and might give you an idea of where to focus. What has changed in your database? They don't just suddenly bloat without some activity in them.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: file size (97)

    I apologize for being so long in replying. I was on vacation.

    I tried the clean database trick and it grew another 17,212 which so close to the 17.278 that it grew the first time. This can't just be a coincidence, can it?

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file size (97)

    The most common (albeit tedious) way to do this is to copy the database, and in the copy, start deleting items one by one to identify the trigger. Does it consistently grow (every use?) or is it somewhat sporadic?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

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

    Re: file size (97)

    In that case, what kind of changes have you made to the database? Oh, and does the database allow storing of images or OLE objects? That is a guarantee of huge bloat.
    Charlotte

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: file size (97)

    The database has only had some minor tinkering done for sveral months now, mostly just rearranging forms. There are no pictures or other external objects.

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: file size (97)

    There are sveral hundreds of elements in this database. This option will have to be a last resort.
    It has been in service for about five years and has never done this till about a month ago. Now it appears to grow by the same amount each time. I just tried the procedure again and it grw 17,228, once again the same amount within a few bytes.

  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: file size (97)

    What are the specifics about the situation? Is this the frontend or backend (or is it both)? Used by more than one person at a time? If a frontend, does everyone have their own copy?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  9. #9
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: file size (97)

    This application started out life as YesICan from Cary Prague (now Business Professional from Database Creations). There are a dozen users on a mix of W98 XP Home and XP Pro each running his/her own copy with data residing on a Novell server. The problem also surfaces on my network which is XP-Pro peer to peer.

    The program has been modified to work on laptops and switch automatically from server to local data source but that mod happened quite a while ago.

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

    Re: file size (97)

    So is it the BE that is bloating or the FE?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: file size (97)

    I was talking about embedded object, not external objects, since external links dont' cause bloat like that. Are the machines that are using this using a runtime Access 97 or are they using a full version of 97 or later?
    Charlotte

  12. #12
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: file size (97)

    Front end. The back end bloats to 5 to 8 times in about a week but has always returned to normal. We have weekly maintenance scheduled for it.

  13. #13
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: file size (97)

    Rick

    There are numerous reasons for a Front End to bloat. This maybe for several reasons and very difficult to diagnose I found this very useful site that has a list of reasons for FE bloat and links to the MS knowledge base. I hope this helps.
    Jerry

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

    Re: file size (97)

    Is it growing by the same amount for every user? If so, it would seem to indicate something like a temporary being created, or something related to importing of data perhaps? I think Charlotte already mentioned the problems caused by importing pictures.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  15. #15
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: file size (97)

    I mentioned in my second post but failed to emphasize that it appears to be the process of importing into a clean database that is the problem. I should say now that this has been a regular occurrence with this particular database as it gets corrupted far more often than is reasonable. As nearly as I can tell the first time it grew was a couple of months ago.

    I've been trying to duplicate the result today (I did it yesterday) but each time I do Access crashes halfway through the forms. I'll have to do the import a couple of dozen at a time. This too has been a somewhat regular occurrence.

    However I may have a clue. Each time I've tried to import and well before it crashes I get an 'error loading an active x component' message. I've identified the form and if I open it to edit I always get the 'save changes' dialogue even though I've not so much as moved the cursor over the form. The fact that this particular form has never been modified nor is it even used just adds to the mystery.
    Is it possible that there is something missing in the 2002 Excel or Word libraries that would have been in 97? Should I just save it and hope?

Page 1 of 2 12 LastLast

Posting Permissions

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