Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004

    Talking Unanswered: Error ORA-00932:Incosistent datatypes in MS Access XP

    When I do a query, search, etc.. inside memo fields in a access form , i get this error:

    Microsoft Access

    ODBC--Call failed.

    [MERANT][ODBC Oracle 8 Driver][Oracle 8]ORA-00932:Incosistent datatypes(#932)

    I have a windows Xp sp1, office 2002 and conecting with a data base oracle 8.16. Sorry for my english level ;-)


  2. #2
    Join Date
    Aug 2007

    Error ORA-00932:Incosistent datatypes in MS Access XP

    Have you gotten a solution for this?

  3. #3
    Join Date
    Jan 2007
    Provided Answers: 12
    If you show us your SQL which is causing the problem, along with the DDL of your tables then I'm sure someone will be able to guide you closer to the solution.
    Home | Blog

  4. #4
    Join Date
    Dec 2004
    Madison, WI
    Quick question - are you somehow trying to also index the memo field? Not sure if it's related to your error but you can't index a memo field. Try changing the memo field to a varchar type field and see if that works. If it does, then you're trying to do something you can't do with a memo data type field. There are some limitations on what you can do with a memo field verses a varchar field.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts