Welcome to SPN

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

Sign Up Now!

Table Size Getting Large

Discussion in 'Information Technology' started by Access Sortof Newb, Jul 28, 2006.

  1. Access Sortof Newb

    Access Sortof Newb
    Expand Collapse

    Good morning,

    I have a table that currently has about 3500 records, but this number
    will be increasing substantially over the next few months to about
    10000+ records. The table holds details for bills of materials for
    electronic component assembly. The table has the following fields:

    BOMID: The BOM that the detail is associated with
    Part Number: The part number for the specific reference locator
    Location: The reference locator

    The problem is that when one of the products gets revised I have to
    reenter the entire BOM, causing multiple duplicate fields every time
    this happens. I was wondering if anybody has an idea that I could use
    to make sure this table does not explode in size simply due to
    revisions and duplicated data.


  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now A Vegetable Market, Ranjit Singh's Royal Haveli A Picture Of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 And The "Periodic Table Of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How Our Entire History Was Dumped In A Horse Stable History of Sikhism Oct 28, 2013

  3. OP
    Nikos Yannacopoulos

    Nikos Yannacopoulos
    Expand Collapse


    I would focus on business needs first, rather than worry about the table
    size. If that's the way it works best for you then leave it as is, the
    table size you are looking at is no big deal!
    Just for comparison, I have over two hundred thousand rows in an invoice
    headers table, with close on a million rows in the related line items
    table; it's a shared back end on a network with about a dozen concurrent
    users, and it works just fine. Contrary to common misconceptions, Access
    is not a toy! It can handle large quantities of data (up to 2GB file
    size) as long as the overall design is good.

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page