If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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 !! |
#2
|
|||
|
|||
#Error error in Form
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 !! |
Thread Tools | |
Display Modes | |
|
|