Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    34

    Unanswered: ODBC Call Fail - when criteria used

    Hi there,

    Weird problem here.

    My query runs fine but when I specify between [date1] and [date2] criteria I get an ODBC call fail.

    I know this is a pretty general error but has anyone else had this error happen when they specified criteria? If so what was the problem?

    Thanks,
    SD
    Last edited by Schoon Dog; 12-13-02 at 14:37.

  2. #2
    Join Date
    Nov 2002
    Location
    Hillsboro, OR, USA
    Posts
    59

    Re: ODBC Call Fail - when criteria used

    I ran into a problem with BETWEEN the other day where the first date was greater than the second date.

    It worked fine in straight Access but failed when I connected it to SQL Server.

Posting Permissions

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