Results 1 to 2 of 2

Thread: Too many fields?

  1. Feb 18th, 2007, 06:49 AM #1
    drimades
    drimades is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    30

    Too many fields?

    MICROSOFT ACCESS

    If I add a field in a table it gives an error:

    "Too many fields defined"

    I have many fields in the table but I don't think it's a limitation of Access. I know that I can define up to 255 fields. Is it true?
    Reply With Quote Reply With Quote
  2. Feb 20th, 2007, 01:53 AM #2
    shakti5385
    shakti5385 is offline
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Arrow Re: Too many fields?

    This Question is not related to the CR
    Read
    Yes you are correct
    The data component of an Access database are the tables. Tables are like spreadsheets where each row is a data record and each column is a distinct field or data feature. The maximum number of fields in a single table is 255. One can include 32,768 tables in a single database .mdb file.
    My Blog : My Article of the day
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width