Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Unanswered: Microsoft JET Database Engine error '80040e14'

    I get the following error when I am writing the following expression; sqlTmp = "SELECT TOP 50 * FROM Delta WHERE Delta.429c='no' ORDER BY Expire DESC"

    Syntax error (missing operator) in query expression 'Delta.429c='no''.

    I have tried several variations and have had no luck maybe someone can help.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    JET wants "double quotes" around strings. You have 'single quotes' there. Try double quoting it and giving it a whirl.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2011
    Posts
    71
    Ok i thought that you can use the orinary SQL Server Transaction Log:to get these type of information ,So please check the link below
    SQL Server Transaction log - A short how-to

  4. #4
    Join Date
    Sep 2011
    Posts
    71
    i thought you should write column name only at where statement

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by paultech View Post
    Ok i thought that you can use the orinary SQL Server Transaction Log:to get these type of information ,So please check the link below
    SQL Server Transaction log - A short how-to
    why would the SQL server transaction log be useful here?

    The OP is specifying that they are using JET, not SQL server
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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