Accessing images from database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Slaphead
    #1

    Accessing images from database

    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


    Tags: None
    • Larry Linson
      #2
      Re: Accessing images from database

      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" <mike@mwgw.free serve.co.uk> wrote in message
      news:bo8v43$4rf $1@newsg1.svr.p ol.co.uk...[color=blue]
      > I have created an Access database of students which includes a STUDENT[/color]
      table[color=blue]
      > and SUBJECT table allowing queries on which subjects each student studies.[/color]
      I[color=blue]
      > 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[/color]
      will[color=blue]
      > then open the corressponding image in an image viewer or perhaps in[/color]
      another[color=blue]
      > Access form.
      >
      > Does anyone know if this is possible with Access and, if so, how should I[/color]
      go[color=blue]
      > about doing it?
      >
      > Cheers
      >
      > Mike
      >
      >[/color]


        Comment

        Previous template Next
        Working...