Microsoft jet error only from some desktops

  • Thread starter Thread starter Jesse Gomes
  • Start date Start date
J

Jesse Gomes

I am getting this error
"The Microsoft jet database engine could not execute the
SQL Statement because it contains a field that has an
invalid data type."

version:Access 97 sr-2

this report used to work on all computer but now it gives
error on win 98 desktops.

It works fine on mine ( Win NT 4).
 
Jessie:

1.) are you postive that all machines have SP 2 installed?
2.) Not withstanding that, that error can occur if you are doing a join, or
some calculation on field that may return a null. Work around this by
looking at your underlying data, and or using the NZ function in the
potentially effected field, specifying a default value if null. Note that
you may also have to wrap the call to NZ with a numeric conversion function
like
CCur(NZ(MyField,0)) to return a number in a query rather than text string
for a field that may contain a null.
 
Back
Top