Memo DataType

[katz]

Hello All!
I realized that many times the Memo data type control, gets corrupted for no
particular reason and displays on the control "error" and I have to delete
the whole record.
Can any bold tell me the problem? Thanks in advance.
Abe

 

[Allen Browne]

What version of Access are you using?

There was a problem with (from memory) the early release of Access 97, which
was fixed years ago in a service pack. A97 SR2 or any version since then
should not exhibit this problem.

If you are experiencing regular corruption in later versions, then something
else is wrong with your setup. If the data is being used over a network, the
network connections would be the place to start looking. If not, perhaps the
computer has other problems that cause it to hang and corrupt the database.

 

[katz]

Thanks Allen.
I 'm using access97, The database dosn't get corrupted only the control with
the DataType Memo.
Abe

 

[Allen Browne]

Choose About in the Help Menu.

If you do not see SR2 after Access 97, you really need to install Service
Release 2 for Office 97.

Not only will that address the issue you are struggling with, but other bugs
too, such as the bookmark bug:
http://allenbrowne.com/bug-04.html