Can anybody tell me why the following is working:
UPDATE JobTicket_024 SET JobTicket_024.file = Replace([file_name], "networkOldPath", "mappeddriveNewPath")
I stole this from a previous update I did to the same table.
Now I'm just changing the path again.
It doesn't seem to be doing...