June - I was under the impression that it was just the name of the image file, on the network, that was being changed to the new ID. Apparently they have assigned a lot of people new IDs, and need to go "find" their prior pictures and get them renamed.
mrod0442 - try this first - find out where on the network these images are stored, and manually rename one to the new name. If the prior empID was AB1234 and the prior image file was AB1234.jpg, and the new empid is CD5678, then rename the image file to CD5678.jpg. then check to see whether the picture is now available.
If that works, then all you need is to rename the files using VBA.
Here's the minimum code to rename files on a windows OS LAN using MS Access VBA as the driver.
Code:
Dim FSObj AS Object
Dim strFromName AS string
Dim strToName AS String
' create a FS object
Set FSObj = CreateObject("Scripting.FileSystemObject")
'iteratively set the from/to names and rename the file
strFromName = "C:\PutThe\FileName\Here\FROMFILE.JPG"
strFromName= "C:\PutThe\FileName\Here\TOFILE.JPG"
FSObj.MoveFile strFromName, strToName
' explicitly destroy what you have created
Set FSObj = Nothing