Database as pure search facility for Document Management

[Rich_the_Brit]

My company is currently in the process of converting to a paperless office
environment. Documents, which have so far been stored on shelves in
lever-arch folders, will be scanned in and stored in a directory structure
with folders and sub-folders on our server (our shared directory).
I wish to establish a database to run alongside as a search facility to find
individual documents. However I dont want to have to create a field stating
the location of the document. Instead I would like to be able to establish a
link from the database directly to the document or somehow arrive straight
there after having searched for and found the desired document.
Can someone tell me the simplest way to do this please.

Thanks
Rich_the_Brit

 

[John Nurick]

Hi Rich,

Think about it: if the database doesn't store the names and locations of
the documents, how can it it possibly find them?

 

[Rajasekhar [MSFT]]

hi

This is Raja

If you are looking for the simplest way.
This would be my suggestion

Assumption : That the Document Name is unique that you store in folders

You can acheive this by using Microsoft access

This is an iDea I have got looking into the problem
----------------------------------------------------

1.create a table in access That countain fields

Documetnid Uniquefield primary key
DocumentName Textfield
PathDocument Hyperlink

2.Create a form based on the table and use that to open the documents

3.You can also create the search form and use that
4.this simplest way is can think