Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    new zealand
    Posts
    17

    Unanswered: Data type mismatch in criteria expresioin

    Hi again, I'm having problems with an insert record page to insert records into a msaccess database via sql and dreamweaver mx.asp pages.

    There are four date fields that can be entered (all not required), but it keep getting the

    ERROR;Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

    from my documentation there seems to be a known problem with msaccess and update/insert server behaviours.....

    Has anyone managed to overcome this issue, and if so, how ??

    thanks for your help....

  2. #2
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163

    Re: Data type mismatch in criteria expresioin

    That may be because of the Date format on the access database.
    Try to insert the date in this format:
    aaaa-mm-dd

    ______________
    Paulo Gonçalves

  3. #3
    Join Date
    Feb 2003
    Location
    new zealand
    Posts
    17
    thanks heaps...I actually got it sorted about 20 minutes before I read your reply...and you were right....I had the msaccess date formats set to an input mask that I don't think dreamweaver took a liking to...

    cheers.

Posting Permissions

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