Microsoft jet error only from some desktops

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).
 
S

SA

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top