Microsoft jet error only from some desktops

Discussion in 'Microsoft Access Reports' started by Jesse Gomes, Aug 6, 2003.

  1. Jesse Gomes

    Jesse Gomes Guest

    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).
     
    Jesse Gomes, Aug 6, 2003
    #1
    1. Advertisements

  2. Jesse Gomes

    SA Guest

    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.
    --
    Steve Arbaugh
    ACG Soft
    http://ourworld.compuserve.com/homepages/attac-cg

    "Jesse Gomes" <> wrote in message
    news:02b301c35c54$520e4120$...
    > 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).
    >
     
    SA, Aug 7, 2003
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mike Wachal [MSFT]

    Jet 4.0 SP8 available in the Microsoft Download Center

    Mike Wachal [MSFT], Oct 17, 2003, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    200
    Mike Wachal [MSFT]
    Oct 17, 2003
  2. Santiago Gomez
    Replies:
    2
    Views:
    211
    Santiago Gomez
    Jan 11, 2004
  3. Ron Johnson

    Microsoft Jet engine could not find the object

    Ron Johnson, Feb 24, 2004, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    194
    prabha
    Feb 25, 2004
  4. Guest
    Replies:
    9
    Views:
    306
    Duane Hookom
    Apr 5, 2005
  5. Guest

    Microsoft Jet database error in report

    Guest, Oct 3, 2006, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    144
    Brendan Reynolds
    Oct 5, 2006
Loading...

Share This Page