Making backup of memo of fields

[John]

Hi

In our access 97 app we are regularly getting this problem that memo fields
come up with #Error in the field and data in memo field is lost. We don't
know what is causing it but it is a big problem as important client related
notes are being lost. Is there a way to setup a character by character
backup on the memo fields which records each keystroke to the disk somehow
which can be retrieved when needed?

Thanks

Regards

 

[Jerry Whittle]

Instead of memo fields, you could use hyperlinks to Word documents. It would
be more trouble to implement, but would work.

The best backup would be frequent, such as nightly, backups of the entire
database.

Another option would be to upgrade to a SQL Server backend. It's tables are
more robust.

Memo fields do have a problem with corruption; however, there is something
causing it to happen. Maybe you can fix the root problem instead of doing a
work-around. Below are some resources on database corruption.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp