Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Location
    Iola, Wisconsin, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fields in Table (2000)

    Does anyone how many fields that you can put in a table? I can't find that information. Help! Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fields in Table (2000)

    Type Specifications in the Answer Wizard and press Enter.
    You should see a subject Access Specifications.
    Expand Table in the right hand pane. You will see that a table can have a maximum of 255 fields.
    You can also look up other specifications here.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Fields in Table (2000)

    But if you are using anywhere near 255 fields in your table, you should stop and seriously reconsider your design! I'd venture to guess that your table structure has major normalization issues.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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