That's why I put the address there. I wasn't sure.
Anyway. I already have a backend db with all my data.
I'm assuming you mean I should create a new db and store
the rich text memo field(s) there?
If so, how might I link the memo field with the pertinent record?

James

"David W. Fenton" wrote in message
36.98...
"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/