How to download OLE Object from MS access?

[shelbytll]

Hi,

I have an Access Database with one of the field's data type as OLE Object. The data can be image, MS powerpoint, MS word etc etc.

How can I use ASP to download the file?

I have tried :
response.contenttype = "application/msword"
response.binarywrite rs("fieldname")

But when I open the file, it is chunk in it.
Moreover I have hard coded the content type. How can I know the content type too?

The user who input the data did not store contenttype or anything at all.

Thanks

I am a clever newbie...