Welcome to SPN

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

Sign Up Now!

Limits to Tables

Discussion in 'Information Technology' started by bgarey, Nov 10, 2005.

Tags:
  1. bgarey

    bgarey
    Expand Collapse
    Guest

    Is there a limit to the number of tables that you can make in Access?
    --
    BG
     
  2. Loading...

    Similar Threads Forum Date
    The Limits of Free Will Interfaith Dialogues Feb 7, 2011
    Bush reaches his limits -- as a cyclist (Reuters) Interfaith Dialogues Jul 10, 2005
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Prurient interest or practical issue?

    If former, check Access HELP on "specifications". If latter, please
    describe more specifics.

    More info, please...

    Jeff Boyce
    <Office/Access MVP>

    "bgarey" <bgarey@discussions.microsoft.com> wrote in message
    news:6EDCBE46-867A-4D31-BFB9-DB17E72C9BB6@microsoft.com...
    > Is there a limit to the number of tables that you can make in Access?
    > --
    > BG
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    bgarey wrote:
    > Is there a limit to the number of tables that you can make in Access?


    It may depend on the version.

    I believe that it limits to about 2,000 open tables and about 32,000
    total objects (which includes tables, forms etc.)

    There are other restrictions as well.

    The question is why are you asking. It sounds like you may have a poor
    database design if you need anywhere close to enough tables to be asking the
    question.

    --
    Joseph Meehan

    Dia duit
     
  5. bgarey

    bgarey
    Expand Collapse
    Guest

    Practical Issue:
    I found the specifications, thanks.
    The data base I am developing would need about 1600 tables for individual
    students and their transcripts.
    Is this practical?
    --
    BG


    "Jeff Boyce" wrote:

    > Prurient interest or practical issue?
    >
    > If former, check Access HELP on "specifications". If latter, please
    > describe more specifics.
    >
    > More info, please...
    >
    > Jeff Boyce
    > <Office/Access MVP>
    >
    > "bgarey" <bgarey@discussions.microsoft.com> wrote in message
    > news:6EDCBE46-867A-4D31-BFB9-DB17E72C9BB6@microsoft.com...
    > > Is there a limit to the number of tables that you can make in Access?
    > > --
    > > BG

    >
    >
    >
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    bgarey wrote:
    > Practical Issue:
    > I found the specifications, thanks.
    > The data base I am developing would need about 1600 tables for
    > individual students and their transcripts.
    > Is this practical?


    I suspect you need two related tables, one for students and one for
    transcripts.


    >
    >> Prurient interest or practical issue?
    >>
    >> If former, check Access HELP on "specifications". If latter, please
    >> describe more specifics.
    >>
    >> More info, please...
    >>
    >> Jeff Boyce
    >> <Office/Access MVP>
    >>
    >> "bgarey" <bgarey@discussions.microsoft.com> wrote in message
    >> news:6EDCBE46-867A-4D31-BFB9-DB17E72C9BB6@microsoft.com...
    >> > Is there a limit to the number of tables that you can make in
    >> > Access? --
    >> > BG


    --
    Joseph Meehan

    Dia duit
     
  7. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Sound like a wrong database structure. It sounds like you want to have a
    separate table for each student - wrong.

    Have one table that list all students with another that list their
    enrollment semesters. Third list their subject for the semester. Fourth
    with the grades for the subject-semester.

    Etc.

    "bgarey" wrote:

    > Practical Issue:
    > I found the specifications, thanks.
    > The data base I am developing would need about 1600 tables for individual
    > students and their transcripts.
    > Is this practical?
    > --
    > BG
    >
    >
    > "Jeff Boyce" wrote:
    >
    > > Prurient interest or practical issue?
    > >
    > > If former, check Access HELP on "specifications". If latter, please
    > > describe more specifics.
    > >
    > > More info, please...
    > >
    > > Jeff Boyce
    > > <Office/Access MVP>
    > >
    > > "bgarey" <bgarey@discussions.microsoft.com> wrote in message
    > > news:6EDCBE46-867A-4D31-BFB9-DB17E72C9BB6@microsoft.com...
    > > > Is there a limit to the number of tables that you can make in Access?
    > > > --
    > > > BG

    > >
    > >
    > >
     
  8. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    As Joseph and Karl have pointed out, having 1600 tables would be a
    remarkably complex design.

    Consider posting back a description of what you are trying to do (not HOW).
    If you have trouble getting started with a description, consider how you
    would explain to an 80 year old grandmother what you were trying to do.
    Hint: no technology!

    Regards

    Jeff Boyce
    <Office/Access MVP>

    "bgarey" <bgarey@discussions.microsoft.com> wrote in message
    news:18A17AE0-0BA9-419F-BD76-FEDF6EF5A8C7@microsoft.com...
    > Practical Issue:
    > I found the specifications, thanks.
    > The data base I am developing would need about 1600 tables for individual
    > students and their transcripts.
    > Is this practical?
    > --
    > BG
    >
    >
    > "Jeff Boyce" wrote:
    >
    >> Prurient interest or practical issue?
    >>
    >> If former, check Access HELP on "specifications". If latter, please
    >> describe more specifics.
    >>
    >> More info, please...
    >>
    >> Jeff Boyce
    >> <Office/Access MVP>
    >>
    >> "bgarey" <bgarey@discussions.microsoft.com> wrote in message
    >> news:6EDCBE46-867A-4D31-BFB9-DB17E72C9BB6@microsoft.com...
    >> > Is there a limit to the number of tables that you can make in Access?
    >> > --
    >> > BG

    >>
    >>
    >>
     

Share This Page