Run-time Error '3340'

I found that the uninstall  previous updates doesn't work with Office 365 and that the only thing I found is to use the deployment tool to set back to a prior version.

Not something I wanted MANY end users who are not all computer saavy to have  to walk through so I did some digging.

We have (primarily) one tool utilizing MS Access which has this error. I don't get it on  my machine because I have a surface, and because I cannot update the drive to a larger one I use an sd card for my user folder which does not allow the  major upgrades to run. However I found a laptop which had the error. I ran the tool and went into debug to find where the offending query was.

It utilized a Update Filename SET field = '0' WHERE nz(field,'')='';

I changed it to eliminate the WHERE statement and it worked.

Update Filename SET field = nz(field,'0');

sure, technically it is Updating each record (I am told) but I  have noticed no significant performance hit.

My thought is  maybe this is only a problem when WHERE is utilized?