photo of patients

  • Thread starter Thread starter Norbert
  • Start date Start date
N

Norbert

What process will you use to store a picture into a form?
The application is a client-server Access 2002 and back
end SQL 2000.
I would like the user just to press cmdbutoon and
automatically take the patient's picture and store it into
the patient's file.
 
Hi there!

Storing binary data (such as a picture) can cause a lot of
headaches and make for some very large databases. I played
with this same problem a little while ago and couldn't
find a good way of making it work.

In the end, I saved the picture file as a JPG in a network-
accessable folder (maybe a web server?), and have the path
to the file saved in the database. It may not seem as
elegant, but it's more efficient as far as network traffic
and storage load on the SQL server.

On the form, use a Picture or Browser control to load up
the picture. Also, I recommend having the picture off by
default and having a "Show Picture" button to load it up,
otherwise browsing through records will be very slow if it
has to load up a picture each time.

Rgds,
Greg
 
Back
Top