importing jpg image from folder through access

[vabsjava]

HI!
i want to import the particular image of the record chosen through asp...
i.e for eg... "select manufacturer, picture from product"
i have saved all the images in the folder named products and the field name is picture...
please help me.... it is urgent

[stnick]

If you have the photo name in a field in the database it becomes very easy, otherwise you'll need to read the directory and get the associated name assuming there is ONLY one photo per directory.

[vabsjava]

If you have the photo name in a field in the database it becomes very easy, otherwise you'll need to read the directory and get the associated name assuming there is ONLY one photo per directory.

I am using this command but is not working

<%response.write ("<img src=C:\Inetpub\wwwroot\products\")%>
<%Response.Write objrs("pictures")%>