"JamesJ" wrote in
:

I also found the following to be useful.

http://www.devx.com/dbzone/Article/42850/1954?pf=true

Overall a fairly good article, but I stumbled over this advice:

store them in a separate backend database

....as a way of avoiding problems with memos. I wonder if the person
writing the article is an xBase refugee, where each DBF file is a
data table and referred to colloguially as a "database," even though
it's actually a data table.

The advice as it stands is insanely wrong, as there's absolutely no
danger of a corrupted memo pointer in one table in an Access data
file somehow polluting the other tables and corrupting their data.
So, I'd definitely change that advice to:

store them in a separate data table

....which will be sufficient to isolate memo corruption from the main
data records.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/