photos on data entry page for DBRW results

[Mary Ann Hailey]

Need your help again... I have tried to figure this out on my own, but I
don't have all of the pieces together to figure it out. I have some forms
(inspection reports and discrepancy reports) that dump data into an access
database for tracking and updating. The forms (and database) are accessed
online by users across the country. The users have requested that they also
be able to attach photos to the form(s). The data is used by several DBRW
pages to extract info for updating, scheduling etc... The users want to be
able to enter the report and upload any applicable photos. Later, they want
to be able to pull up the online report, see if there are photos attached,
and view the photos. Some reports may only have one photo, but I expect that
to be the exception rather than the rule.

In don't know HTML code very well, but have been able to do some simple
things in it. From what I have read, photos don't 'play well' with Access
2003, and I don't expect to be upgrading Access any time soon. With that in
mind, what would be the best way to approach this task?

Any help or direction is very much appreciated.

 

[Stefan B Rusynko]

The DBRW does not support file upload
- will require custom server side scripting
Can be done using FSO
See http://www.asp101.com/articles/jacob/scriptupload.asp
- or if your host supports it w/ API's like ASPupload
See http://www.aspupload.com/

While you can save the uploaded images to the DB (using a binary write)
- it is not recommended
(instead save the filename & location to the DB and the image file to a folder w/ write permissions)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Need your help again... I have tried to figure this out on my own, but I
| don't have all of the pieces together to figure it out. I have some forms
| (inspection reports and discrepancy reports) that dump data into an access
| database for tracking and updating. The forms (and database) are accessed
| online by users across the country. The users have requested that they also
| be able to attach photos to the form(s). The data is used by several DBRW
| pages to extract info for updating, scheduling etc... The users want to be
| able to enter the report and upload any applicable photos. Later, they want
| to be able to pull up the online report, see if there are photos attached,
| and view the photos. Some reports may only have one photo, but I expect that
| to be the exception rather than the rule.
|
| In don't know HTML code very well, but have been able to do some simple
| things in it. From what I have read, photos don't 'play well' with Access
| 2003, and I don't expect to be upgrading Access any time soon. With that in
| mind, what would be the best way to approach this task?
|
| Any help or direction is very much appreciated.