Accessing images 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

[Larry Linson]

Yes, it is possible, and you can download from http://accdevel.tripod.com
sample databases illustrating three approaches to handling images in Access.
It's not the application you describe, but should help with the
image-handling part of it. Feel free to use the code as a starting point,
but bear in mind that it is an example, not a finished application.

Larry Linson
Microsoft Access MVP
"Slaphead" <mi**@mwgw.freeserve.co.uk> wrote in message
news:bo**********@newsg1.svr.pol.co.uk...

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