I'm surprised that works as you should have a space before WHERE
This is a simpler version of your existing code:
Code:
DoCmd.RunSQL "UPDATE tblEquipment SET tblEquipment.EquipPic = 'D:\ACCESS\EQUIPMENT\321SHARK_2021-08-21_PIC.jpg'" & _
" WHERE tblEquipment.EquipID=1;"
Or better still:
Code:
CurrentDb.Execute "UPDATE tblEquipment SET tblEquipment.EquipPic = 'D:\ACCESS\EQUIPMENT\321SHARK_2021-08-21_PIC.jpg'" & _
" WHERE tblEquipment.EquipID=1;", dbFailOnError
If your string variable is called strText then you would use
Code:
CurrentDb.Execute "UPDATE tblEquipment SET tblEquipment.EquipPic = '" & strText & "'" & _
" WHERE tblEquipment.EquipID=1;", dbFailOnError