Linked images in Access 2000

[Kojak43]

I have made a database in Access that keeps track of photographs that we have licensed for our client. One of the fields in the tblPhoto table is OLE and that is where I place thumbnail sized jpg's (2 to 5 kb's in size)

I save the images in a folder called "Images", however, when I am entering the data into the tblPhoto table, I go to the Images folder, select the image number, copy the image and paste it into the OLE field of the tblPhoto.

Even tought I would have preferred to link the images, I think I enbedded the images. I say this because the database has gotten quite large (37Mb) I think if the images were linked, the database would probably be fewer than 10 Mb.

So, two questions
1- How can I link what was previously embedded, WITHOUT having to reinvent that wheel. All my photos are in one folder, therefor the path would be constant, just the image number would change.
2-How do I link an image to begin with? When asked if I wanted to link or embedd, I selected link. However this has gotten so bloated, I must have done something wrong. For example, I have never been asked for the path, so I can not see how it could be linked. Usually I work in a query that duplicates the table. I have never been able to figure out where it wants me to enter the path and file name for that OLE field.

Any guidance would be appreciated.

 

[lewatkin]

Kojak,

Try this link...numerous examples and how to's dealing with images. Hope you find something useful there!!

http://www.granite.ab.ca/access/imagehandling.htm

Lee

 

[twinlizards]

Hey I was wondering if u could help me get images inserted into my access file. I cannot seem to get it in to readm "long binary data", usually it says "package" or something else and when I run my program, I get an errror

thx
mike

 

[Kanga35]

In my table I have 2 fields one for Thumbnail and one for the actual picture. Thumbnail is a text box where I enter the path while Picture is a Hyperlink.
On my form I have a field as an image with picture type as linked and the picture property in code to equal the thumbnail text address. Next to that thumbnail I have a text box linked to the Hyperlink to get to the picture and labelled "Zoom".

Note: On the server my thumbnails are Gif when the pictures are jpg.

 

[twinlizards]

In my table it is only 1 row for the image to be. And this image it says "long binary data". When I try and replace the slot in the row where the picture is, I get package or bimap. It does tell me about OLE which my files are written to or for. How do I get my bitmap file to be this, long binary data. Can I do this through my Visual Basic in the Database file maker? Or should Access be able to convert?

 

[Kanga35]

You probably have saved the image data into a text field or such. Your data has also probably been trunkated to fit the field. Not much luck there. Try what I suggested in previous mail... it works, I have tens of thousands of artworks on file.

 

[twinlizards]

I inhereted this program from afriend and i didn't want to start over but just alter or add on to this. how do i save the image into that text field? i would like to try that but will my program still recognise it?