Link, not embed, images in a form

[snowboarder234]

Don't need the = sign when binding directly to field but probably doesn't hurt.

You don't show the entire path of the image file. Is it prefixed with drive letter? Do you have a Windows Explorer mapping to the drive letter? Or is the path using UNC?

The image name does not have a suffix (.png, .jpg, .bmp). The FULL name needs to be stored, this includes the suffix.

Thank you for responding to my question.
I didn't add the = sign. The system added it automatically after I inserted the field name with brackets before and after the name. That makes me question if there's still something I'm doing incorrectly as it pertains to the control source.

I blocked out the full path because I'm a little nervous about broadcasting the entire path which leads to the server. It goes something like this:
\\servername\foldername\foldername\foldername\ .... etc., until it gets to the actual image file.

I know I can store the images on the local drive, but again, I feel in the long run it's prudent to plan now to prevent database bloat later on. Additionally, this database will be stored locally, as well as on the server where it will be viewed by another person. That's another reason why I feel it's important to have the images linked to the server files as opposed to being embedded on my desktop. I'm working on the premise that if the images are embedded in the database on my computer and my computer crashes, the copy of the database on the server will end up with the images being deleted? Is that correct?

And lastly, I can take care of inserting the suffix -- thanks, I didn't know that was necessary.

[June7]

I reviewed the PM you sent me. Let me know if the reply did not get to you.

That would be a very nasty crash. Yes, if the db could not be recovered and the images are not anywhere else, they are gone.

[snowboarder234]

Okay [thx for the response to the private message] I give up on this for now. Going back to embedding images since as you advised earlier, 222 images is not a large database. I don't think we'll be adding more than 50 records a year.

Having said that, now when I try to insert an OLE object in the ole table field I get an error message that says "The operation on the OLE object failed.....the ole server may not be registered.....to register server reinstall it. Little confused because I've successfully embedded objects before so don't know why I'm getting this message now.

[June7]

I've never used the OLEObject field or control.

I have used the Attachment field and Image control.