Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max num of fields in a table (97 Sr2)

    What are the maximum number of fields you can have in one table?

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

    Re: Max num of fields in a table (97 Sr2)

    A table can have 255 fields. You can find most of these limitations yourself in Access Help. In Access97, anyway, open Help and type in "Specifications", then select "Microsoft Access" from the list offered.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max num of fields in a table (97 Sr2)

    However, as I recall there is a also maximum record size in A97 that does not include the size of your memo and OLE fields, so if you have lots of large text fields you'll run into problems before you reach 255 fields.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max num of fields in a table (97 Sr2)

    Go to help and search on specifications / Microsoft Access. This will give you all the limits for Access 97.

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

    Re: Max num of fields in a table (97 Sr2)

    The max. record size in Access97 is 2000 bytes. This is the size of the actual record, and is not the sum of the field sizes (which could be more). It does not include Memo fields (other than I think a 16-byte pointer to the actual location of the memo contents); and same with OLE objects.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Max num of fields in a table (97 Sr2)

    Let me just point out that if you every even get close to the maximum number of fields, there is something seriously wrong with your database design.
    Charlotte

Posting Permissions

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