Has anyone experienced problems with memo fields getting corrupted in databases that are accessed by several users simultaneously on a network (Access97)?<br>
<br>
I've found 2 instances in the past month where the word "#Error" is displayed in the memo field. If I try to put the cursor in the field in table view, it will not let me. I can repair the database, which does not fix the problem, but I cannot compact the database, it errors.<br>
<br>
The only way around this problem is to make a new table, and import all the records except the one with the memo error.<br>
<br>
Thanks in advance for advice
<br>
I've found 2 instances in the past month where the word "#Error" is displayed in the memo field. If I try to put the cursor in the field in table view, it will not let me. I can repair the database, which does not fix the problem, but I cannot compact the database, it errors.<br>
<br>
The only way around this problem is to make a new table, and import all the records except the one with the memo error.<br>
<br>
Thanks in advance for advice