Avatar of pcalabria
pcalabria
Flag for United States of America asked on

Trouble populating picture control in ms access

A couple lines of code started throwing an error message today.  This code has worked for months without every causing an error.
We are using Win10 machines and Access o365
Microsoft put out a windows update last night.

                        strURL="NoImage.jpg"
                        strPath = "\\fileserverpro\Database\ImagesPackage\PS1\" & strURL
                        Me.PackageImage.Picture = strPath


The error message is:
MyAppName can't open the file
\\MyServer\Database\MyImageFolder\PS1\NoImage.jpg

1. The problem shows up on multiple machines... all of which were able to work without error yesterday.
2.  When I type the path into my browser the image opens:
Path: \\MyServer\Database\MyImageFolder\PS1\NoImage.jpg
MicrosoftMicrosoft 365Microsoft AccessWindows OS

Avatar of undefined
Last Comment
pcalabria

8/22/2022 - Mon
Daniel Pineault

Just a stab in the dark, but did you receive any updates in the last day or two?  Perhaps, as a test, revert your build back to an earlier build no. on one machine to see if the problem goes away.  If it does, you know it's another update bug (please report this if it is the case!).
John Tsioumpris

Probably something in the path
If you want to stop chasing paths and files you could take a look at my article : https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html
If you have quite a lot of pictures and since you are on a network then probably you need to switch Database engine to a more robust for file handling like Firebird
ASKER CERTIFIED SOLUTION
pcalabria

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes