I want to create a database of pdf, xls, ppt, doc files that I have created or downloded from the net.(files will be stored in the databse) I have about 200 such files which is growing at 5% per month. I want to use MS Access 2000 as the database application. My OS is Win 98SE.
The database should have the following features:
> Text search abilities in both title and content.
> The file should open from the database. ie. if i click on a file(say pdf) in the database it should open in its native application (acrobat reader).
> Simple to maintain. A novice like me should be able to maintain and make minor repairs, etc.
## Deliverables
A simple design of tables and their relationships. (i already have this but it can be improved by professionals. I can send this if requested).
A form to query the database by author, title, date, subject, file format, keywords.
Results from the query should open by clicking on a link or double clicking on the file object itself.
## Platform
Win 98 SE
MS Access 2000
MS IE 6+
Intel P4 with 256MB