#Error error in Form

Hi,

I have a database in MS Access 97 which has a form consisting mainly
of "Memo" fields. It is accessed by a number of people. Every now and
then, if the database is left open or sometimes upon closing it and
reopening it, it corrupts some of the fields on the form and displays
#Error in the field instead of the actual text.

You can then no longer edit any field on the form nor can you edit any
field from the back-end in the table linked to the form. You cannot
even copy the record directly from the table and paste it back in
after removing the #Error message.

As a result, you have to copy each field manually to MS Excel - delete
the #Error message and paste it back into the table. The previous
record is corrupted and hence has to be deleted. Is there any way
round this problem i.e how to make sure we don't get this #Error
message as trying to resolve it by copying to Excel etc. is quite a
tedious task.

Thanks !!

There was a bug in earlier versions of Access 97 where memo fields were
corrupted, but it was fixed in the service packs. What service pack do you
have? Open Access, and choose About on the Help menu.

If you do not see "Access 97 SP2, then download it from he
http://www.microsoft.com/downloads/d...DisplayLang=en

It would also be a good idea to ensure you have the latest JET 3.5 SP:
http://support.microsoft.com/kb/172733

If you do have SP2 applied, it should not be corrupting like that. If the
data is being read across the network, you may have a connection dropping
out.

For general suggestions on how to avoid corruption, follow through each of
the items in this article that apply to your version:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Suyash" wrote in message
...

I have a database in MS Access 97 which has a form consisting mainly
of "Memo" fields. It is accessed by a number of people. Every now and
then, if the database is left open or sometimes upon closing it and
reopening it, it corrupts some of the fields on the form and displays
#Error in the field instead of the actual text.

You can then no longer edit any field on the form nor can you edit any
field from the back-end in the table linked to the form. You cannot
even copy the record directly from the table and paste it back in
after removing the #Error message.

As a result, you have to copy each field manually to MS Excel - delete
the #Error message and paste it back into the table. The previous
record is corrupted and hence has to be deleted. Is there any way
round this problem i.e how to make sure we don't get this #Error
message as trying to resolve it by copying to Excel etc. is quite a
tedious task.

Thanks !!