Searching document in the db

Posted on 2004-11-30
Last Modified: 2012-05-05
I have an Acess database that stores Word docs files.
Is there a way (ASP) to perform a search on the docs in the database?

Question by:alberte
    1 Comment
    LVL 6

    Accepted Solution


    How about this:

    Create another memo field. Use it to store an Text or HTML version of your Word document. Update the field every time the the document is updated. This will you can search this field instead.

    Now, you'll need some way to get the text out of all the .docs. You can do this manually or use MS Word automation or a library like wvWare :      

    Windows version:

    Basically, you'll need a script to loop thru all records, read the word doc, convert it to text, and then update the text field with it.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Purpose To explain how to place a textual stamp on a PDF document.  This is commonly referred to as an annotation, or possibly a watermark, but a watermark is generally different in that it is somewhat translucent.  Watermark’s may be text or graph…
    A short article about a problem I had getting the GPS LocationListener working.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now