ole object inserting

[rummy]

does anyone know how to insert a scanned image into a database without storing the image inside the database

 

[DougP]

I created Real Estate program where there were a LOT of digital camera images (the properties were .jpgs)<br><br>By not having the images in the database it keeps the database size small.<br>I created a form and &quot;loaded&quot; each image at the time it was needed.<br>This also precluded each image was named the Real Estate ID<br>like so 299329.jpg<br>Or you could have the full path and image name in another field like ImageLocation = &quot;F:\Images\299329.jpg&quot;<br>-----------------------------<br>Private Sub Form_Current()<br>&nbsp;&nbsp;&nbsp;&nbsp;If Me![ID] &lt;&gt; 0 Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me!Image14.Picture = &quot;p:\ViewPhotos\Photos\&quot; & Me![ID] & &quot;.jpg&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Label20.Caption = &quot;File: &quot; & &quot; p:\ViewPhotos\Photos\&quot; & Me![ID] & &quot;.jpg&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;End If<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>End Sub<br>----------------------------------<br>This code was in the forms &quot;On_current&quot; event so everytime you move to a new record it loads an image<br>PS it is a tiny bit slow on a slow machine.<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.