Activate a BLOB record into a link

[sfunk]

Hello.

I have a database that is storing a Title, Description, and a .wav as a BLOB in an Access DB. When I display the list of records in the table the <%=(Recordset1.Fields.Item(&quot;Sound_Blob&quot.Value)%> shows up with 3 question marks.

What I need is a clickable link that will play the .wav file. The way it is on my site now is the wav files are stored in a directory and I have a hyperlink that opens and plays the wav file from the browser.

http://www.FartsFartsFarts.com/fart_sound_list.asp

(to show you how it works now.

I know I'm going to get comments about the negatives of storing binaries in a database. I'm doing this as an excercise because I haven't worked with BLOBS before.

Sincerely,
Steve