Results 1 to 9 of 9

Thread: My Access DB is INFLATING Like a Balloon!

  1. Sep 17th, 2002, 02:39 PM #1
    scottgman
    scottgman is offline

    Thread Starter
    New Member
    Join Date
    Sep 2002
    Posts
    4

    My Access DB is INFLATING Like a Balloon!

    Hi All,

    I'm working on an app in VB6 Pro that reads/writes to an Access 97 DB. When the DB was first created it was 94k. But after I run the app and clear the data from the database several times, I notice that the DB keeps getting bigger. The DB has only 3 tables and no more than 10 fields per table. At one point this DB was 20MB after I deleted all the data. Does anyone have any idea why this is happening and how I can fix it?

    Thanks,
    Scott
    Reply With Quote Reply With Quote
  2. Sep 17th, 2002, 08:31 PM #2
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    Hi Scott,

    The reason it is "inflating" is because when you delete something out of access it actually isnt really deleted.
    It is held in access until you "compact" the database!

    So you just have to compact it!

    Are you using a replica set by chance?

    ciao
    b
    Reply With Quote Reply With Quote
  3. Sep 17th, 2002, 10:36 PM #3
    MasterEvilAce
    MasterEvilAce is offline
    Member MasterEvilAce's Avatar
    Join Date
    Jul 2002
    Posts
    60
    open the database in Microsoft Access and look for the option to compact
    and there you go!

    you can also compact it using VB.. search the forum, or i can post code
    Reply With Quote Reply With Quote
  4. Sep 18th, 2002, 03:36 AM #4
    aidan
    aidan is offline
    Lively Member
    Join Date
    Sep 2002
    Posts
    103
    If something that is deleted is still in the database until it is compacted, is it possible to 'undelete' this. If so - how?

    Aidan
    Reply With Quote Reply With Quote
  6. Sep 18th, 2002, 03:53 AM #5
    BShadow
    BShadow is offline
    Hyperactive Member
    Join Date
    Jan 2002
    Location
    The Netherlands
    Posts
    425
    You can compact your database form your software too... Look at the tip form vbworld: http://216.26.168.92/tips/tip482.html
    "Experience is something you don't get until just after you need it."
    Reply With Quote Reply With Quote
  7. Sep 18th, 2002, 05:47 AM #6
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    Originally posted by aidan
    If something that is deleted is still in the database until it is compacted, is it possible to 'undelete' this. If so - how?

    Aidan
    It is deleted, but the space for this data is not given free.

    So unless you compact the db it keeps growing even if you delete all rows from all tables each day
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  8. Sep 18th, 2002, 08:56 AM #7
    BShadow
    BShadow is offline
    Hyperactive Member
    Join Date
    Jan 2002
    Location
    The Netherlands
    Posts
    425
    Originally posted by aidan
    If something that is deleted is still in the database until it is compacted, is it possible to 'undelete' this. If so - how?

    Aidan
    Isn't that called a rollback??? I'm not so experienced in Databases, so I'm guessing here...

    I have no idea how to do such a thing though...
    "Experience is something you don't get until just after you need it."
    Reply With Quote Reply With Quote
  9. Sep 18th, 2002, 09:28 AM #8
    scottgman
    scottgman is offline

    Thread Starter
    New Member
    Join Date
    Sep 2002
    Posts
    4

    Thank You

    Wow! Thanks for all the replies... big help! I didn't know about compacting the database... doh! Anyway, thanks again, and thanks for the link to the code.

    Cheers!
    Scott
    Reply With Quote Reply With Quote
  11. Sep 18th, 2002, 09:31 AM #9
    BShadow
    BShadow is offline
    Hyperactive Member
    Join Date
    Jan 2002
    Location
    The Netherlands
    Posts
    425
    No problem at all...

    Could you place *RESOLVED* in your subject (after the current one) so that when users search they know that this one has an answhere...


    Good luck!
    "Experience is something you don't get until just after you need 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