If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
How many MEMO fields allowed in a table?
In Access2002, what is the maximum number of MEMO fields that I can have in a
single table, before getting an error? Thanks!! |
#2
|
|||
|
|||
How many MEMO fields allowed in a table?
255, which is the maximum number of fields that you can have in one table.
-- Ken Snell MS ACCESS MVP "Dennis" wrote in message ... In Access2002, what is the maximum number of MEMO fields that I can have in a single table, before getting an error? Thanks!! |
#3
|
|||
|
|||
How many MEMO fields allowed in a table?
Dennis
Why do you ask? Is this a hypothetical question, or were you planning to use multiple memo fields? If so, please describe why you think you need/want multiple memo fields. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... In Access2002, what is the maximum number of MEMO fields that I can have in a single table, before getting an error? Thanks!! |
#4
|
|||
|
|||
How many MEMO fields allowed in a table?
Unfortunately, my user is requiring that a table which is using many TEXT
fields (all set to 255 bytes), needs to be able to be more verbose in all of them. Since 255 is my limit, my only choice is to use memo fields. However, I've run into certain situations where I generated a "record too large" error when using some number of them (in another application). That necessitated a complete database redesign. I am HOPING to avoid that here, but I'm kind-of doubtful. "Jeff Boyce" wrote: Dennis Why do you ask? Is this a hypothetical question, or were you planning to use multiple memo fields? If so, please describe why you think you need/want multiple memo fields. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... In Access2002, what is the maximum number of MEMO fields that I can have in a single table, before getting an error? Thanks!! |
#5
|
|||
|
|||
How many MEMO fields allowed in a table?
Access has a limit of (?)2,000 characters per record ... that would be why
multiple text fields at 255 characters each would exceed the limit. If you'll provide a bit more specific description of the domain you are working in, the newsgroup readers may be able to offer alternate approaches. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... Unfortunately, my user is requiring that a table which is using many TEXT fields (all set to 255 bytes), needs to be able to be more verbose in all of them. Since 255 is my limit, my only choice is to use memo fields. However, I've run into certain situations where I generated a "record too large" error when using some number of them (in another application). That necessitated a complete database redesign. I am HOPING to avoid that here, but I'm kind-of doubtful. "Jeff Boyce" wrote: Dennis Why do you ask? Is this a hypothetical question, or were you planning to use multiple memo fields? If so, please describe why you think you need/want multiple memo fields. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... In Access2002, what is the maximum number of MEMO fields that I can have in a single table, before getting an error? Thanks!! |
#6
|
|||
|
|||
How many MEMO fields allowed in a table?
I understand this. However, MEMO fields (at 65,535 characters max each) are
not handled the same way as other field types. So my question stands: how many MEMO type fields can I have in a table, before I'll get the "record too long" error? If no one knows, then I'll have to experiment, but I was hoping for a quicker answer than that. "Jeff Boyce" wrote: Access has a limit of (?)2,000 characters per record ... that would be why multiple text fields at 255 characters each would exceed the limit. If you'll provide a bit more specific description of the domain you are working in, the newsgroup readers may be able to offer alternate approaches. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... Unfortunately, my user is requiring that a table which is using many TEXT fields (all set to 255 bytes), needs to be able to be more verbose in all of them. Since 255 is my limit, my only choice is to use memo fields. However, I've run into certain situations where I generated a "record too large" error when using some number of them (in another application). That necessitated a complete database redesign. I am HOPING to avoid that here, but I'm kind-of doubtful. "Jeff Boyce" wrote: Dennis Why do you ask? Is this a hypothetical question, or were you planning to use multiple memo fields? If so, please describe why you think you need/want multiple memo fields. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... In Access2002, what is the maximum number of MEMO fields that I can have in a single table, before getting an error? Thanks!! |
#7
|
|||
|
|||
How many MEMO fields allowed in a table?
Feel free to post back with what you discover.
You might also try checking on-line with search terms like "MS Access Memo field". It seems you've already determined what solution will be used. I wasn't asking to be nosy. It may be that the "solution" doesn't match the "problem"... Best of luck! Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... I understand this. However, MEMO fields (at 65,535 characters max each) are not handled the same way as other field types. So my question stands: how many MEMO type fields can I have in a table, before I'll get the "record too long" error? If no one knows, then I'll have to experiment, but I was hoping for a quicker answer than that. "Jeff Boyce" wrote: Access has a limit of (?)2,000 characters per record ... that would be why multiple text fields at 255 characters each would exceed the limit. If you'll provide a bit more specific description of the domain you are working in, the newsgroup readers may be able to offer alternate approaches. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... Unfortunately, my user is requiring that a table which is using many TEXT fields (all set to 255 bytes), needs to be able to be more verbose in all of them. Since 255 is my limit, my only choice is to use memo fields. However, I've run into certain situations where I generated a "record too large" error when using some number of them (in another application). That necessitated a complete database redesign. I am HOPING to avoid that here, but I'm kind-of doubtful. "Jeff Boyce" wrote: Dennis Why do you ask? Is this a hypothetical question, or were you planning to use multiple memo fields? If so, please describe why you think you need/want multiple memo fields. Regards Jeff Boyce Microsoft Office/Access MVP "Dennis" wrote in message ... In Access2002, what is the maximum number of MEMO fields that I can have in a single table, before getting an error? Thanks!! |
#8
|
|||
|
|||
How many MEMO fields allowed in a table?
If so, then Memo fields must be excluded as I have records with two Memo fields each in excess of 3,000 characters. On Thu, 13 Sep 2007 13:26:52 -0700, "Jeff Boyce" wrote: Access has a limit of (?)2,000 characters per record ... that would be why multiple text fields at 255 characters each would exceed the limit. If you'll provide a bit more specific description of the domain you are working in, the newsgroup readers may be able to offer alternate approaches. Regards Jeff Boyce Microsoft Office/Access MVP |
#9
|
|||
|
|||
How many MEMO fields allowed in a table?
On Thu, 13 Sep 2007 19:29:58 -0500, Michael Gramelspacher wrote:
If so, then Memo fields must be excluded as I have records with two Memo fields each in excess of 3,000 characters. On Thu, 13 Sep 2007 13:26:52 -0700, "Jeff Boyce" wrote: Access has a limit of (?)2,000 characters per record ... that would be why multiple text fields at 255 characters each would exceed the limit. If you'll provide a bit more specific description of the domain you are working in, the newsgroup readers may be able to offer alternate approaches. Regards Jeff Boyce Microsoft Office/Access MVP From Access Help + Specifications + Access Specifications + Tables Number of characters in a record (excluding Memo and OLE Object fields) 2,000 -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#10
|
|||
|
|||
How many MEMO fields allowed in a table?
On Thu, 13 Sep 2007 11:38:01 -0700, Dennis
wrote: Unfortunately, my user is requiring that a table which is using many TEXT fields (all set to 255 bytes), needs to be able to be more verbose in all of them. Since 255 is my limit, my only choice is to use memo fields. However, I've run into certain situations where I generated a "record too large" error when using some number of them (in another application). That necessitated a complete database redesign. I am HOPING to avoid that here, but I'm kind-of doubtful. Memo fields will PROTECT you from the "record too large" error. It's triggered when the total size of a record exceeds 2000 characters - but memo fields count only 16 characters toward that limit, no matter how large the memo field. HOWEVER... memos have disadvantages. They cannot be indexed; sorting will truncate them to 255 bytes; they can't be used in relationships; searching can be slow. The fact that each record "has many text fields" and that you're pushing the "record too large" limit worries me, though! It's quite possible that you have a one (record) to many (comments) relationship embedded in each record of this table, and that a one to many relationship to a Comments table such as: Comments CommentID Autonumber Primary Key ParentID foreign key to your table Comment Memo CommentDate Date/Time, default Now() CommentBy text, default CurrentUser() might be preferable. John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|