NZ() is not an Excel function so I think you would get a compile error
unless you had checked a reference to the Access Type Library.

rstThingy.open is an ADO/DAO method, so you must also have ADO/DAO checked
as a reference.

Maybe the ADO/DAO type library and dlls are local to the PC (which I would
expect since they basically come with Windows/office these days), but for
some reason the Access type library is on a remote server?

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"Maury Markowitz" wrote in
message ...
"NickHK" wrote:
This is an Access function, no ?
How are you calling it ?

thingy = Nz(rstThingy!aField, "")

Nothing special.

However, the "The Remote Machine is not accessible" error sounds like a
networking problem, albeit intermittent.

I think this is the case, but why would only the Nz function fail? Why
not,
say rstThingy.open, for instance?

Maury