Results 1 to 6 of 6

Thread: DB too large

  1. Nov 6th, 2003, 10:04 AM #1
    vbgladiator
    vbgladiator is offline

    Thread Starter
    Frenzied Member vbgladiator's Avatar
    Join Date
    May 2001
    Posts
    1,950

    DB too large

    Hi,

    I have an application which is written in Access. It was always around 5MB (the mdb file, the mde around 3.5). Today, I just made a simple little change (no new object, just small code change) and the database grew to 21MB.
    Any Ideas why?
    I can't have it that bid.

    Thanks,
    Don't anthropomorphize computers -- they hate it
    Reply With Quote Reply With Quote
  2. Nov 6th, 2003, 10:32 AM #2
    MartinLiss
    MartinLiss is offline
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431
    Did you just delete a bunch of records, perhaps more than once? Deleted records are only removed from sight and not actually deleted until the database is compacted, so you might try compacting the database.
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  3. Nov 6th, 2003, 11:16 AM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    Dude, it's Access.

    No explanations. The things I've had to deal with.... but those days are behind me.
    Reply With Quote Reply With Quote
  4. Nov 6th, 2003, 11:31 AM #4
    vbgladiator
    vbgladiator is offline

    Thread Starter
    Frenzied Member vbgladiator's Avatar
    Join Date
    May 2001
    Posts
    1,950
    Yes, it's Access, he he he. The client had this thing done in Access and they don't want to pay for rewriting so we're stuck with this thing.

    No, the application doesn't contain any tables just table links.
    I ran compact repair, decompiled the damn thing, nothing.
    Don't anthropomorphize computers -- they hate it
    Reply With Quote Reply With Quote
  6. Nov 6th, 2003, 12:14 PM #5
    JPicasso
    JPicasso is offline
    Fanatic Member JPicasso's Avatar
    Join Date
    Aug 2001
    Location
    Kalamazoo, MI
    Posts
    843
    What was this "small code change"?
    Merry Christmas
    Reply With Quote Reply With Quote
  7. Nov 6th, 2003, 12:19 PM #6
    vbgladiator
    vbgladiator is offline

    Thread Starter
    Frenzied Member vbgladiator's Avatar
    Join Date
    May 2001
    Posts
    1,950
    Never mind.
    The main form has their logo on it.
    They recently sent me a new image file to replace the old logo.
    I just realized that it's 800KB and the old one was 20KB.
    I resized the image file and now it's fine.

    I can't believe that the file size jumped from 5 MB to 21 MB because of a difference of 780KB in an image file.

    Thanks,
    Don't anthropomorphize computers -- they hate it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width