uploading images from webcam to database

[rick_it]

Hey Everyone!

Goal: using a motion detection camera I'd like to upload the pictures
directly into a database? If this is doable, how can I do it?

Thanks for your input.

rick

 

[Douglas J. Steele]

Access doesn't handle image data very well (although that's changed in
Access 2007).

You'd be far better off saving the pictures as files on the hard drive, and
then linking to them from the database.

 

[rick_it]

Doug,

thanks for your input. That's not a problem I can upload the images on the
server and link them to my db.

I tested my webcam last night. Unfortunately, when the camera detected some
motion, it started taking pictures until no more motion was detected. That
was not good!

This is what I need to do:
1) someone enters the office
2) webcam takes 1 shot
3) shot is automatically entered into a database
4) at a later moment, user will review the shots and add comments to each
customer (i.e. potential customer, friend, etc.).

Any idea on how to achieve this?

Thanks

Rick

 

[Douglas J. Steele]

Sounds as though the issue is with your camera and its software, not with
Access. You'll need to ask in a more appropriate forum than this one.