problem: recordset-binding of picture element in mdb file. 1

[chenwenjun]

Recordset-binding of picture element in mdb file
I want to make a access file which contains picture record. But I face 2 big problems:
Problem1: I can not have this image element shown in webpage!
Problem2: the size of mdb file grows too big. (if you add a picture of 65kb,the size of mdb increases by 2M)
I think these questions are typical for those who are running picture viewing web site...
Help me please
Thanks "Learn till the last breath."

 

[schase]

an easier solution is to just store the filename into a database field, then call that field when you want to display the image.

so say tblImages has a field fldFileName
and populated into that field is a record called house6.jpg

When you want to pull it back out you just do.
(after you create your recordset)

<img src=&quot;images/<%=recordset1.fields.item(&quot;fldFileName&quot%>&quot;>

&quot;Never underestimate the power of determination&quot;

Stuart