Re: is there a maximum number of text fields?

Tech-Archive recommends: Fix windows errors by optimizing your registry


"John Spencer" <spencer@xxxxxxxxx> wrote in message
news:eizhoDjQGHA.4896@xxxxxxxxxxxxxxxxxxxxxxx
There is a maximum of 255 fields in any one table. But the counter does
not reset when you delete a field. Also, if you change a field type that
uses up one of the 255 slots.

Try compacting your database and changing a few of the fields and saving
the changes. Then compact again, and do some more fields if needed.

Now, let me say that a table with that many fields is very, very rare.
You probably have a table design issue and need to split out your data
into more tables. ALSO, there is a 2000 character limit in a row, so you
could run into that as a problem.


Just to add to John's point (in case it is not clear to the OP):
While you can have a record with 219 text fields, if each of those fields
contained "0123456789" then the record would break the 2000
characters/record limitation and so you couldn't save this record.
And to back up the other point, I have been designing databases for over ten
years and normally my tables might have 10,20,30 fields but almost never
more than that. If you feel you really need 219 fields, peraps you could
let us know why.


.

Relevant Pages

  • Re: is there a maximum number of text fields?
    ... I really need to find or put together a FAQ for this issue. ... Try compacting your database and changing a few of the fields and saving ... ALSO, there is a 2000 character limit in a row, so you ... And to back up the other point, I have been designing databases for over ...
    (microsoft.public.access.gettingstarted)
  • Re: Access Compact/Repair in ADO.Net?
    ... Here's the VB6 function that actually does the compacting: ... I keep a file in the same folder as my database, ... opening the database, and if it is, it doesn't let the user run the app. ... Name strSource As strDest ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Can be access by mutiple users?
    ... wouldn't shut down quickly enough due to Access doing compacting. ... Compacting is somewhat of a futile pursuit as the database usually just ... a properly split database should not need compacting ... I'm a little confused about the report thing. ...
    (microsoft.public.access.gettingstarted)
  • RE: Can be access by mutiple users?
    ... "Jerry Whittle" wrote: ... wouldn't shut down quickly enough due to Access doing compacting. ... Compacting is somewhat of a futile pursuit as the database usually just ... I'm a little confused about the report thing. ...
    (microsoft.public.access.gettingstarted)
  • Re: Incredible Expanding Database!
    ... > One is your position that the database will stay large because it does not ... worth of attachments and HTML messages might be such a time. ... of messages and attachments, then it will significantly reduce the size. ... Compacting (as opposed to doing a full ...
    (microsoft.public.mac.office.entourage)