Full text

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • JT

    Full text

    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


  • John

    #2
    Re: Full text

    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

    Working...