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\
Me.PackageImage.Picture = strPath
The error message is:
MyAppName can't open the file
\\MyServer\Database\MyImag
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\MyImag
We are using Win10 machines and Access o365
Microsoft put out a windows update last night.
strURL="NoImage.jpg"
strPath = "\\fileserverpro\Database\
Me.PackageImage.Picture = strPath
The error message is:
MyAppName can't open the file
\\MyServer\Database\MyImag
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\MyImag
MicrosoftMicrosoft 365Microsoft AccessWindows OS
Last Comment
pcalabria
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!).
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
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
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.