Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I archieve database file to decrease the size of the file

Discussion in 'Information Technology' started by FrankRussell, Jul 28, 2006.

  1. FrankRussell

    FrankRussell
    Expand Collapse
    Guest

    Access data base. I need to purge some old data to make the file smaller. I
    delete file entries in the tables but that does not decrease the size of the
    file.

    Help

    Thank You
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Thu, 20 Jul 2006 09:31:02 -0700, FrankRussell wrote:

    > Access data base. I need to purge some old data to make the file smaller. I
    > delete file entries in the tables but that does not decrease the size of the
    > file.
    >
    > Help
    >
    > Thank You


    Access does not restore deleted file space until after you also
    compact the database.
    Click on Tools + Database Utilities + Compact and Repair database
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    FrankRussell <FrankRussell@discussions.microsoft.com> wrote:

    >Access data base. I need to purge some old data to make the file smaller. I
    >delete file entries in the tables but that does not decrease the size of the
    >file.


    I realize you've already deleted the data but why even bother? Leave
    it around for comparison or reporting purposes.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page