I'll buy that.All I can say is, it worked for me.....
I'll buy that.All I can say is, it worked for me.....
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I tried ssanfu's suggestion. No joy. The query does run properly if I remove the Left() function from the criteria row.
This I find odd
You are the user in this case, logging on to her pc from somewhere else. Did you try any posted solution, e.g. looking for file versions rather than updates? I don't know if you're the IT guy or not, so maybe an update was rolled back and the updated dll remains and is being used as inIf I open the accde on the problem computer from my computer it runs fine, but if I log on to her computer remotely, I get the error.
https://answers.microsoft.com/en-us/...2-efb3fd8f3e0d
I was going to suggest that the query may be corrupt and all you did by importing it into a new db was bring over the corrupted object. However, this quoted statement suggests it's not the cause.
The
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Found the problem! There was a reference to BarCodeWiz ActiveX, but BarCodeWiz had not been installed on this computer. Once installed, everything works.
Well, I think NoellaG deserves kudos and a prize for that answer way back.
I learned something - not sure why Left has anything to do with that library, but I guess strange things do happen.
Given that the user only had runtime, you could not compile the project on that pc, but if you had been able to, you probably would have found the problem sooner.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thx for the prize . The explanation is quite simple: if the program isn't installed Access can't find the dll on the moment it is loading all referenced libraries. On that moment it stops loading referenced libraries. And the standard library containing standard functions like left() is one of the remaining dll's that isn't loaded anymore. I found out that when a user complains that the function left() doesn't work anymore it is in 99.9% of the cases a missing referenced library.