I have a large db that has a field to store paths to photos on my server.

I have created an OLE field to enable me to embed the photos from the 
server to the db.

Is there a procedure that allows me to automate the above process as I 
have over 78k photos to embed.

TIA.

Hi,

Do I understand your request correctly?    If so, I would ask if you are re
ally sure you want to embed 78,000 photos in a db????

(Maybe other people on this message board have some way to keep the size of
 embedded images down, but I haven't had any luck with "on board" images.  
 I'd love to find a way.)

I would urge you to test that issue.   Just make up a little test db with a
n empty table to hold OLE images and create a OLE field for photos.

Before you add any photos...compact the db and look at the size of your .md
b(or whatever) file.

Then, add just one single OLE photo.

Compact it again.

Check the file size again.   I think you will see a huge change in size.

Imagine how big your mdb will be with 78,000 photos.   What you are asking 
for may be far larger than you would wish.

There have been previous threads on storing the *path* to an image, and the
n using the path to be able to display it ... no absurd db bloat that way.

It's simple and works very well.

Charlie








> I have a large db that has a field to store paths to photos on my server.
>
> I have created an OLE field to enable me to embed the photos from the
> server to the db.
>
> Is there a procedure that allows me to automate the above process as I
> have over 78k photos to embed.
>
> TIA.