D
David Taylor
I am developing a small document management application in Access 2003 - SQL
Server is not an option. The application will store, catalog and retrieve
(search) documents (.doc, .xls and .pdf).
My problem is with searching for text in these documents. I would prefer to
index entire documents so that when users enter some search text, the app
can search those indexes rather than doing a "Like *text*" operation in SQL.
Similar, I think, to the way "Full Text Search" works in SQL Server.
So how do I go about indexing entire Word, Excel and Adobe PDF documents in
VBA?
Grateful for any suggestions.
DT
Server is not an option. The application will store, catalog and retrieve
(search) documents (.doc, .xls and .pdf).
My problem is with searching for text in these documents. I would prefer to
index entire documents so that when users enter some search text, the app
can search those indexes rather than doing a "Like *text*" operation in SQL.
Similar, I think, to the way "Full Text Search" works in SQL Server.
So how do I go about indexing entire Word, Excel and Adobe PDF documents in
VBA?
Grateful for any suggestions.
DT