Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / August 2004

Tip: Looking for answers? Try searching our database.

Database as pure search facility for Document Management

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rich_the_Brit - 19 Aug 2004 10:49 GMT
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 - 19 Aug 2004 20:25 GMT
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?

>My company is currently in the process of converting to a paperless office
>environment.  Documents, which have so far been stored on shelves in
[quoted text clipped - 9 lines]
>Thanks
>Rich_the_Brit

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Rajasekhar [MSFT] - 19 Aug 2004 22:16 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.