Welcome to SPN

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

Sign Up Now!

Reducing Database Size

Discussion in 'Information Technology' started by Richie P, Nov 2, 2005.

  1. Richie P

    Richie P
    Expand Collapse
    Guest

    I frequently have to import data into different Access databases for analysis
    and these databases are normally quite large (around a GB). After analyzing
    them, I normally need to record the results in a table. (This can happen
    several times). And although I remove the initial tables to try to reduce the
    size of the database (to stay under the 2GB limit), the database continues to
    remain the same size.

    Is there anyway to permanently remove this data so that I don't exceed the
    limit with any databases? I know that I could split the databases, but I have
    to do this on many databases and this would double, triple, or quadruple the
    workload for a single project.

    Thanks in advance if anyone can help!

    Rich.
     
  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. Ofer

    Ofer
    Expand Collapse
    Guest

    When you remove tables or data from the mdb, it doesn't reduce the size of
    the MDB, for that you need to compact the MDB.

    Look at this link
    http://office.microsoft.com/en-us/assistance/HP051874491033.aspx

    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "Richie P" wrote:

    > I frequently have to import data into different Access databases for analysis
    > and these databases are normally quite large (around a GB). After analyzing
    > them, I normally need to record the results in a table. (This can happen
    > several times). And although I remove the initial tables to try to reduce the
    > size of the database (to stay under the 2GB limit), the database continues to
    > remain the same size.
    >
    > Is there anyway to permanently remove this data so that I don't exceed the
    > limit with any databases? I know that I could split the databases, but I have
    > to do this on many databases and this would double, triple, or quadruple the
    > workload for a single project.
    >
    > Thanks in advance if anyone can help!
    >
    > Rich.
     

Share This Page