Hello,
I need to store the text of documents into an Access database in order to be
able to locate the documents by searching phrases that are contained in the
documents (*).
But, an Access database is not something that we could call "secure", in
fact anyone can enter and see what is inside. Even setting a password (this
database will have one) it's rather easy for anyone to find the password
(with a program) and gain access.
What I want is to encrypt the text of the documents.
It doesn't have to be an encryption aimed for experienced hackers or
crackers, it's mostly for "advanced users" (for example like me) for not
being able to see the texts. But of course, if it's stronger, the better.
But there are some requirements:
I want to still be able to search for phrases in the documents with an SQL
query (I use DAO), of course encrypting also the phrase before the search.
Another requirement could be not to increase the size of the texts too much.
Suggestions?
Thanks in advance.
(*) With the program the users won't have access to the full text of the
documents, but they just will be able to perform searches.