127 character limit in Memo field

[Maura via AccessMonster.com]

I am working in A2000. I have a Memo field on a form, to which the User
enters a description of their problem. I am using an Append query to add the
"description" to a table. From the table, I am generating an Issues report
which includes the "description." Everything works perfect unless the User
types in more than 127 characters in the "description" field. Upon typing the
128th character, the entire content of the field turns to junk characters
(similar to small rectangles).

I have reviewed the posts related to this problem, and, while it's comforting
to know that I am not the only person dealing with this issue, there has been
no solution posted. I have checked all the parameters on the table and the
form, and they are set correctly for a Memo field. I have also downloaded all
the patches, as suggested by MS support.

Has anyone found a solution or workaround to this problem?

 

[Gina Whipp]

Maura,

Sounding like corruption... MAKE a BACK-UP FIRST!!!!! How big is your
database and when was the last time your Compact & Repair. You might also
try importing everything into a new database. I am also ASSUMING everyone
has their own front end, if this is a shared database...

Have a look at...

http://www.granite.ab.ca/access/corruption/symptoms.htm. I would make a
back-up, make another back-up and then first try importing everything into a
new database. Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm. And after all
of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances
apply to you.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[wilhelmmt via AccessMonster.com]

Thanks for your response, Gina. I have considered the possibility of
corruption, as suggested by other responders, and have performed all of the
suggested resolutions. Unfortunately, the problem isn't a corrupted database.
I have reproduced this error in several different databases, both shared and
single user. This must be a problem with A2000 since I have not seen any
higher version users reporting a similar problem.

Maura,

Sounding like corruption... MAKE a BACK-UP FIRST!!!!! How big is your
database and when was the last time your Compact & Repair. You might also
try importing everything into a new database. I am also ASSUMING everyone
has their own front end, if this is a shared database...

Have a look at...

http://www.granite.ab.ca/access/corruption/symptoms.htm. I would make a
back-up, make another back-up and then first try importing everything into a
new database. Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm. And after all
of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances
apply to you.

I am working in A2000. I have a Memo field on a form, to which the User
enters a description of their problem. I am using an Append query to add

[quoted text clipped - 17 lines]

Has anyone found a solution or workaround to this problem?

 

[Gina Whipp]

Maura,

Access 2000 or higher allows alot more then 127 characters in the Memo
field. It has nothing to do with the version. You did not post if you
tried importing the objects into a clean database or the size of your
database. Also, is this table linked?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks for your response, Gina. I have considered the possibility of
corruption, as suggested by other responders, and have performed all of
the
suggested resolutions. Unfortunately, the problem isn't a corrupted
database.
I have reproduced this error in several different databases, both shared
and
single user. This must be a problem with A2000 since I have not seen any
higher version users reporting a similar problem.

Maura,

Sounding like corruption... MAKE a BACK-UP FIRST!!!!! How big is your
database and when was the last time your Compact & Repair. You might also
try importing everything into a new database. I am also ASSUMING everyone
has their own front end, if this is a shared database...

Have a look at...

http://www.granite.ab.ca/access/corruption/symptoms.htm. I would make a
back-up, make another back-up and then first try importing everything into
a
new database. Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm. And after
all
of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances
apply to you.

I am working in A2000. I have a Memo field on a form, to which the User
enters a description of their problem. I am using an Append query to add

[quoted text clipped - 17 lines]

Has anyone found a solution or workaround to this problem?

 

[wilhelmmt via AccessMonster.com]

Gina,
Yes, I did set up a clean database in case there was a corruption; no, the
table is not linked; and the database size is 2.32 MB. I've decided to quit
wrestling with this problem, and limit the data entry to what is now a text
(changed from memo) field to 127 characters. I will provide an additional
text field, and will concatenate the fields for the report.

Maura,

Access 2000 or higher allows alot more then 127 characters in the Memo
field. It has nothing to do with the version. You did not post if you
tried importing the objects into a clean database or the size of your
database. Also, is this table linked?

Thanks for your response, Gina. I have considered the possibility of
corruption, as suggested by other responders, and have performed all of

[quoted text clipped - 30 lines]

 

[Gina Whipp]

Maura,

While I'm glad you found a solution I would caution that finding out what is
causing an unusal and unheard of issue should be a priority as it could lead
to other more serious issues.

Best of Luck,
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,
Yes, I did set up a clean database in case there was a corruption; no, the
table is not linked; and the database size is 2.32 MB. I've decided to
quit
wrestling with this problem, and limit the data entry to what is now a
text
(changed from memo) field to 127 characters. I will provide an additional
text field, and will concatenate the fields for the report.

Maura,

Access 2000 or higher allows alot more then 127 characters in the Memo
field. It has nothing to do with the version. You did not post if you
tried importing the objects into a clean database or the size of your
database. Also, is this table linked?

Thanks for your response, Gina. I have considered the possibility of
corruption, as suggested by other responders, and have performed all of

[quoted text clipped - 30 lines]

Has anyone found a solution or workaround to this problem?

 

[John W. Vinson]

Thanks for your response, Gina. I have considered the possibility of
corruption, as suggested by other responders, and have performed all of the
suggested resolutions. Unfortunately, the problem isn't a corrupted database.
I have reproduced this error in several different databases, both shared and
single user. This must be a problem with A2000 since I have not seen any
higher version users reporting a similar problem.

A2000 was a notoriously buggy and unreliable version. It had several service
packs before the much more stable AccessXP came along and replaced it. I don't
believe it's still under service by Microsoft but you might check to see if
you have all available service packs installed - or upgrade to A2003 (probably
not to 2007, since the user interface changed so drastically with that
release).

 

[wilhelmmt via AccessMonster.com]

Thanks John for your suggestion to upgrade to A2003. I just tested the
Description field and was able to enter over 127 characters. Finally I can
move past this problem!

 

[John W. Vinson]

Thanks John for your suggestion to upgrade to A2003. I just tested the
Description field and was able to enter over 127 characters. Finally I can
move past this problem!

Glad it was so simple!