Accessing image files from database

[Slaphead]

I have created an Access database of students which includes a STUDENT table
and SUBJECT table allowing queries on which subjects each student studies. I
want to create another table called DOCUMENT which holds details of any
assignments, essays, etc the student produces. I want to be able to scan
these documents and store then on the pc as images. I also want to include
the path to each image in the appropriate DOCUMENT record so that queries
can be run to show all documents for each student. Selecting a douemnt will
then open the corressponding image in an image viewer or perhaps in another
Access form.

Does anyone know if this is possible with Access and, if so, how should I go
about doing it?

Cheers

Mike

 

[MacDermott]

One way would be to store the full path to the document in a hyperlink-type
file. You can then open the document in its native application (as defined
on your PC) just by clicking on the hyperlink.

HTH
- Turtle

 

[Mike Webb]

Interesting. I'm quite new at this, so could you tell me
how I'd do a "hyperlink-type file" in Access, or point me
to the right place in the Access help file? I am
scanning newspaper articles and need to reference those
files somehow in a table.

Thanks in advance.
Mike

 

[MacDermott]

My finger must have slipped -
I meant a Hyperlink type FIELD.
When you define the field in the table's design view, Hyperlink is one of
the options.
You can type a path/filename into the table; it will be displayed blue
and underlined, and clicking on it will open that file.
One drawback is that once it's been entered, you have to right-click on
it to be able to edit it - a normal click opens it!

HTH
- Turtle