You can use a memo field to store the text, I would suggest a standard
text field for keywords as an alternative way to search, perhaps as an
option to the user. If you wanted to make that fairly intelligent then
use vba to index the words in the memo field as word (count of word)
and then eliminate common words like the,and,of, etc. with this you
could provide rudimentary "relevance" to the search terms by returning
those documents with the highest count of keywords.
regards,
John O'Brien
Applied Computer Science
jobrien AT acscience DOT com
"JT" <jatomaszcz@poc zta.onet.pl> wrote in message news:<bofhdr$2r 5$1@zeus.polsl. gliwice.pl>...[color=blue]
> Hi! Is it possible to create full-text databases in Access? I'd like to
> store electronic journal articles which I want to search.
> Jack[/color]
Comment