st***********@sbcglobal.net wrote:
Hi and thanks,
I have a Journalist database for tracking writers from various
magazines and would like a field that could hold the text of their
articles as they are published. The Memo field would allow 65K
characters but with time even this would not provide the necessary
space.
The field need not hold graphics, although that would be nice if
possible, and I will not need to run queries against it. It is simply
to be a holding area for ongoing examples of articles they have
written.
Is this a case for an OLE field (which I have never used before)? By
embedding a Word object as a field does Access create a separate Word
document for each record or is this kept internally within the
Journalist database file?
I am running Access 2002 SP3 on XP Pro SP2.
Thanks again, Steve
Does your DOCUMENT really need to be stored in Access? You could make
the document a HYPERLINK and open the document in whatever format it
came in...a text file, a Word Doc, a PDF.
Baring that, you could still save the doc as a text file on the network,
wherever. Then using Open...#1 you could get the file length. If the
filelen is less than 65K, store the value to the string and into a memo.
If greater than import in chunks...show in incrments of 65K. Have a
combo to list how many chunks there are and then have the user select
the chunk.
You might be better off using a Hyperlink. Then you don't need to worry
about images etc.