Displaying Images From Access 2002 by SQL Through FP 2002

[Larry]

Hello.

I am attempting to display images from an Access DB on to
an .asp page through FP 2002. The searchable text comes up
just fine (different field associated with the image),
however; the image does not display properly.

When I follow the directions provided by MS for FP2000:

http://support.microsoft.com/default.aspx?
scid=/support/frontpage/fp2000/aspweb/page00010.asp

I get the broken image link. I believe this is because
Access stores the image as an OLE Binary object and FP
cannot convert the image properly. Does anyone know of a
way to strip out the OLE/Binary headers prior to transfer?
I am also needing to do the same with Adobe Acrobat .pdf
files as well - but if I can solve (or someone can help me
solve) the riddle of the image, the pdf portion shouldn't
pose a problem. Thank you!

 

[Jim Buyens]

-----Original Message-----

Hello.

I am attempting to display images from an Access DB on to
an .asp page through FP 2002. The searchable text comes
up just fine (different field associated with the image),
however; the image does not display properly.

When I follow the directions provided by MS for FP2000:

http://support.microsoft.com/default.aspx?
scid=/support/frontpage/fp2000/aspweb/page00010.asp

I get the broken image link. I believe this is because
Access stores the image as an OLE Binary object and FP
cannot convert the image properly. Does anyone know of a
way to strip out the OLE/Binary headers prior to
transfer?
I am also needing to do the same with Adobe Acrobat .pdf
files as well - but if I can solve (or someone can help
me solve) the riddle of the image, the pdf portion
shouldn't pose a problem. Thank you!

Dear (e-mail address removed):

I answered this same question just four days ago for
(e-mail address removed). As I recall, however, johnb asked
about Microsoft Access rather than SQL Server. Here's a
relevant article regarding SQL server.

173308 HOWTO: Display Images Stored in a BLOB Field

http://support.microsoft.com/default.aspx?scid=kb;en-
us;173308

I suggest the two of you collaborate and then, if either
of you have any specific questions regarding my previous
answer, please post them.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*