Access 2000 Microsoft Picture / Picture to asp page

[dug]

Hi all,


Thanks in advance for the assist.
I have an access 2000 form with an OLE object field where I copy and
paste images from a word document or an excel document. This gets
inserted to the tables.


Now the question:
I want to print out the contents of that table in an HTML/ASP page.
That is the information associated with the picture and the picture
itself.


This will allow me to have the website online, update the database
offline (with copy and paste from word or excel) and then upload the
databsae to the site.


The issue is when I retrieve the image its all garbage. Is tehre a way
for me to correct this so that the image displayed is JPG/GIF. I dont
want like an embedded micrsoft doc, just the image itself.


Thanks again, hope someone can help, am in a real bind here.

 

[Arvin Meyer [MVP]]

Copy and paste each image into a separate file. Store the path to the file
in the database. Use the path of the file as the HTML SRC for the image in
the ASP page.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[dug]

I can easily create an asp page that uploads the imaegs to the server
and creates the link in the db. However I am trying to avoid this on
purpose. I want the functionaliy of drag and drop from word to the OLE
Object in access and then upload the db and display contents with asp.
As there is a ton of pictures to upload and they are all in Excel or
Word, it would mean saving each pic individually and uploading them.
The way that I am thinking of allows the drag and drop to access form
which is simpler. At the same time I can have a form to display all the

uploaded images and their details as an offline catalogue for the user
(only 1 user so no issues with synchronization).


The only issue that I have is when I copy and paste the image from word

or excel into the OLE Object field I get a Microsoft Picture or Picture

(excel) entry in the field. I need to be able to "convert" this via asp

to an image to be displayed. Or even convert this picture in access to
another form and use as to view it.


Thanks for the assist