Module for searching multiple .doc files on multiple terms?

[atticuswang]

Hello All,

Info on system setup:

So I have an Access 2003 DB that is being used for career opportunities. This
database sits behind my website where people can go to submit applications
and upload their resumes in word.doc format. Every time a resume is upload it
is place on a network drive that has a folder named "Resumes". This folder
contains about 8500 files.

My question...

Is there any sort of method that can be used to do a search on all of these
word.doc's using multiple criteria? I know that you can do a simple search
using Windows that would be "one word or phrase in the file", but I would
like to use more than just one word or phrase to go through every document
and return some result.

Any suggestions?

 

[Tom van Stiphout]

The problem with this approach is that you end up looking for the
various (mis-)spellings of terms. A much better approach is to index
each resume: maintain a list of all keywords used in each document.
That lookup will be very fast.
For a similar app I enhanced this further: we kept a list of all the
(mis-)spellings and their corresponding keyword, so we could automate
the indexing to large extent.

-Tom.

 

[atticuswang via AccessMonster.com]

How is it that you would go about this, Tom?

The problem with this approach is that you end up looking for the
various (mis-)spellings of terms. A much better approach is to index
each resume: maintain a list of all keywords used in each document.
That lookup will be very fast.
For a similar app I enhanced this further: we kept a list of all the
(mis-)spellings and their corresponding keyword, so we could automate
the indexing to large extent.

-Tom.

Hello All,

[quoted text clipped - 15 lines]

Any suggestions?