update query not updating

[turnerkdavid]

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 anything. What gives?

Thanks in advance.

P.S. Since this is my first post I am unable to include what is considered a link. So hopefully the following makes sense:
"networkOldPath" = "backslashbackslashOldPath"
"mappeddriveNewPath" = "F:backslashNewPath"

I hope that makes sense.

 

[turnerkdavid]

Sorry I should have included the following:

Windows 7
MS Office 10 (32 bit)
Access

64bit machine

 

[BlueIshDan]

One thing I need to know is, is this in a query definition or in a vba module?

The reason I ask is the double quotation marks will be different in these two environments.

 

[turnerkdavid]

query definition

 

[BlueIshDan]

 UPDATE JobTicket_024 SET [COLOR="Red"]file[/COLOR] = Replace([[COLOR="red"]file_name[/COLOR]], "networkOldPath", "mappeddriveNewPath")

 

[turnerkdavid]

Thanks Bluishdan, but still a no go.

 

[BlueIshDan]

I didn't edit anything, I simply pointed out that you're fields don't match as I would expect them to.

 

[turnerkdavid]

Oh, right. I changed that too, but still a no go.
For testing purposes I changed it to a SELECT query instead of UPDATE just to see what was happening.
Interestingly, the query shows a table and then an error message pops up with "Data type mismatch in criteria expression" and as soon as I click "help" it clears the table. And, the field isn't updated either.

 

[turnerkdavid]

F#*#k

There was a typo in my select statement. That's why it wasn't finding anything in the search/select column.

Sorry for the troubles.

Thanks for helping.