can anyone tell how i can include pictures stored in an access database to an asp page (based on record selection)?? i am totally lost

Are the pictures themselves stored in the database or just the url to the pictures?

I have the url in mine and all you do is click on the insert image icon as normal and then in the image selection box that opens, at the top where it says "Select File Name From" choose data sources and this will bring up your recordsets, simply choose the field that corresponds to your image url and off you go.

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

just a parallel question here, Davecl. Do you know how to retrieve a picture from a database field (like a BLOB field in MySQL)? I've been wondering about that for a long time...

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

Thanks i will give it a try

Hi Julio

You mean the actual picture itself is stored in the database?
I have never done it that way so I can't really help you but I'm sure there are plenty of folks in here who have, maybe one of them would like to jump in now??

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

yeah, i know you can store files in BLOB fields, in binary format... i'm just not sure about how you would go about extracting them from the database and actually displaying them in a page....

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

There is a tutorial on retrieving images in BLOB/Binary format from an Access DB...

www.stardeveloper.com/articles/display.html?article=2001040401&page=1

<b>Connman21</b>
www.conncreativemedia.com
<b>DEVELOPMENT SETUP</b>
DW MX Studio
Web Server: IIS5
DB: Access2000/SQL2000
OS: XP Pro
Language: ASP/VB