Bug report: Table fields of type MEMO are chunked 'cause of CONSTR

[Peter]

1. Problem:
Contents in table fields of data type "memo" are chunked to a length of max
255 chars, if the fields are delivered by a query having the key word
"CONSTRAINT".

2. Reproduction with minimal extend:
a) new Access DB
b) new table having two fields: ID (AUTO) and my_text (MEMO)
c) filling my_text with a text more than 255 chars
d) switching to SQL view, adding CONSTRAINT
e) switching to data view, facing that the text in my_text is chunked at
byte 255

Thanks for taking note.

If you google around for "microsoft bug report" or else, you see a lot of
opinions some of which are useless. WHERE IS THE ONLY AND OFFICIAL PLACE
WHERE BUGS CAN BE REPORTED TO MICROSOFT?

Best
Peter


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...6b1a502f38&dg=microsoft.public.access.queries

 

[Peter]

Sorry, I've written the wrong key word. The right one is DISTINCT. Once again:
1. Problem:
Contents in table fields of data type "memo" are chunked to a length of max
255 chars, if the fields are delivered by a query having the key word
"DISTINCT".

2. Reproduction with minimal extend:
a) new Access DB
b) new table having two fields: ID (AUTO) and my_text (MEMO)
c) filling my_text with a text more than 255 chars
d) switching to SQL view, adding DISTINCT (SELECT DISTINCT ...)
e) switching to data view, facing that the text in my_text is chunked at
byte 255

Thanks for taking note.

If you google around for "microsoft bug report" or else, you see a lot of
opinions some of which are useless. WHERE IS THE ONLY AND OFFICIAL PLACE
WHERE BUGS CAN BE REPORTED TO MICROSOFT?

Best
Peter

 

[fredg]

Sorry, I've written the wrong key word. The right one is DISTINCT. Once again:
1. Problem:
Contents in table fields of data type "memo" are chunked to a length of max
255 chars, if the fields are delivered by a query having the key word
"DISTINCT".

2. Reproduction with minimal extend:
a) new Access DB
b) new table having two fields: ID (AUTO) and my_text (MEMO)
c) filling my_text with a text more than 255 chars
d) switching to SQL view, adding DISTINCT (SELECT DISTINCT ...)
e) switching to data view, facing that the text in my_text is chunked at
byte 255

Thanks for taking note.

If you google around for "microsoft bug report" or else, you see a lot of
opinions some of which are useless. WHERE IS THE ONLY AND OFFICIAL PLACE
WHERE BUGS CAN BE REPORTED TO MICROSOFT?

Best
Peter

This is a known issue.
See Allen Browne's July 2006 response to a previous poster on this
issue.

http://groups.google.com/group/micr...3861a4e28cf?lnk=st&q=&rnum=2#bc0793861a4e28cf

Also see Microsoft Knowledgebase articles:
259893, 889490, 254845 which deal with additional issues in memo
fields due to formatting, etc.

 

[Allen Browne]

This is not a bug: it is by design.

Explanation:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html