Using Microsoft Access (2003)
I have a form with a text box called PicFileName and an Image Control called PersonImage
The intent is that the following code will cause .jpg (picture) to appear in PersonImage, without the .jpg being embedded in the table behind this form (in order to save space)
The following code accomplishes this perfectly:
Dim strPicName As String
Dim strPicPath As String
Dim strSource As String
strPicPath = C:\Pix C:\Pix is the folder containing the jpg
strPicName = ABCD.jpg ABCD.jpg is the filename of the picture
strSource = "" & strPicPath & strPicName & "" in this case it will be C:\Pix\ABCD.jpg
If Not IsNull(Me.PicFileName) And Me.PicFileName <> "" Then
Me.PersonImage.Picture = strSource
As I said this works perfectly in all computers on my LAN, EXCEPT for ONE which returns an error 2114 saying that this code is not supported OR the jpg is too large! I have reduced the size of the .jpg to a few K, to no avail.
ALL COMPUTERS ON THE LAN USE THE SAME OS (Win 10 Pro), AND THE SAME VERSION OF ACCESS, AND GET THEIR JPG FROM THE SAME FOLDER, and the above process runs perfectly for the last six years!!
QUESTION: What needs to be adjusted in the one computer where this is not working?