Importing Files

Hi, I was wondering if anyone could let me know if this is
possible. What I'm looking at doing is creating a database
that keeps track of all corresondence (letters, reports,
etc.) The correspondence would then be scanned onto the
computer. Information like DateReceived, Sender, etc.
would be entered into the database. I'd like to be able to
then go back and search through the database for certain
correspondence and then be able to view the correspondence
from the results. I would assume this can be done, but if
it is a difficult task please let me know as I'm a new
Access user. If it is difficult I would assume it would be
best to add a FileName and PlaceOnFile field to the
database to be entered in with each scanned document, so
that way the results of the query/search would just show
the user where to get access to the file? Any
help/comments would be appreciated...thanks!

-----Original Message-----
Hi, I was wondering if anyone could let me know if this
is
possible. What I'm looking at doing is creating a
database
that keeps track of all corresondence (letters, reports,
etc.) The correspondence would then be scanned onto the
computer. Information like DateReceived, Sender, etc.
would be entered into the database. I'd like to be able
to
then go back and search through the database for certain
correspondence and then be able to view the
correspondence
from the results. I would assume this can be done, but
if
it is a difficult task please let me know as I'm a new
Access user. If it is difficult I would assume it would
be
best to add a FileName and PlaceOnFile field to the
database to be entered in with each scanned document, so
that way the results of the query/search would just show
the user where to get access to the file? Any
help/comments would be appreciated...thanks!
.


Osmond,

Create your table with a field that is a hyperlink. When
you add records, DateRec, Sender, Type etc. you will trace
the path to the file that has been scanned.

John Parkinson