-----Original Message-----
Does anyone know how to upload a picture to an access
database via a web page. I can upload a pic to a file
but cannot upload to an access field.
Does anyone know how to does this. Thank you,
I can only answer this in general terms: You would need to
write an ActiveX object, probably in VB6, that opened the
picture file, converted it to an OLE object, and then
stored the OLE object in the database.
To research this further, consult the following article,
which addresses the parallel task of making a Web page
display picture stored ih Access.
MSKB article 175261
HOWTO: Retrieve Bitmap from Access and Display It in Web
Page
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;175261
I must warn you, though, that acutally storing the picture
bits in the database is a very uncommon, difficult, and
resource-intensive approach. It's *much* more
conventional, easy, and efficient to store a picture
*filename* in the database. That way, to display the
picture, you avoid gyrations such as MSKBarticle 175261;
instead, you just construct an <img src=> tag that gets
its file name from the database.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
