I'm wondering if I could get some input on how to design a database. I'm working on a project that involves searching for key phrases in a folder with over 1000 word documents. I'm aware of the search function in Windows, but I need to do it with Access because I want to incorporate a web interface for searching.
Currently, I have a table with the filename, a hyperlink to the file that opens the file, and the content (where I copy the content and place it in a memo field). I'm not sure if this is the best way to go about it because the data is redundant with the files and the content in the database.
I want this project to turn out similar to a search engine. Any ideas? Please help. Thanks!!