Results 1 to 13 of 13
  1. #1
    Join Date
    Mar 2007
    Posts
    6

    Question Unanswered: deleting a table doesnt change the file size

    when i delete tables from an ms access file its size doesnt change,
    just wonderd why is that?

    btw i found that when i do compact database it fixes it...
    just wondered if there is other ways...

    thanks,

    guy.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Reading the first part of your posting I was going to suggest compacting before I scrolled down and saw the rest of it! As I understand it, things in Access are deleted but apparently the memory isn't released until it's compacted or until the objects are imported into a blank db. Another example would be controls on forms. The number of controls on a form is limited to 754. If you place a number of controls on a form then delete them, they still count towards that 754 limit.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The data and objects are only flagged for deletion. They are only physically removed from the file once compact and repair is run. This is a feature rather than a bug (as such running compact and repair does not "fix the problem"). Apart from anything else it allows recovery of data and objects if you don't run compact & repair.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Say you have a 1GB access file and you felete 500Mb of data...
    It would appear to still be 1GB until you compact and repair OR the file gains a new 500Mb+ of data (pushing overall size above the original pre-delete size) - Then it just keeps couting.
    George
    Home | Blog

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    couting?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by georgev
    Say you have a 1GB access file and you felete 500Mb of data...
    It would appear to still be 1GB until you compact and repair OR the file gains a new 500Mb+ of data (pushing overall size above the original pre-delete size) - Then it just keeps couting.
    Items logically deleted but not physically deleted will be overwritten by new objects\ data.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    @Rudy - yes, "counting"

    @everyone else - What poots said!
    George
    Home | Blog

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    felete? ()
    Testimonial:
    pootle flump
    ur codings are working excelent.

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Hush you
    George
    Home | Blog

  10. #10
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by georgev
    Hush you
    <mock scouse>Caaaaaaaaaaalm down</mock scouse>
    its a brave person who crosses the path of the self styled "Webs Cuddliest Hitflump"
    I'd rather be riding on the Tiger 800 or the Norton

  11. #11
    Join Date
    May 2005
    Posts
    1,191
    Brits


    Just kidding
    Me.Geek = True

  12. #12
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by healdem
    <mock scouse>Caaaaaaaaaaalm down</mock scouse>
    its a brave person who crosses the path of the self styled "Webs Cuddliest Hitflump"
    . lol
    George
    Home | Blog

  13. #13
    Join Date
    Mar 2007
    Posts
    6
    coolness,

    thanks very much for the help

Posting Permissions

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