Access Error: sytax error in query

Discussion in 'ASP.NET / ASP.NET Core' started by bweisse, Jun 3, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. bweisse

    bweisse

    Using Frontpage, I had imported an Access db then used the access data wizard in order to view the data. When I went to view the information, I recieved the following error message:
    Database Results Error
    Description: Syntax error in query. Incomplete query clause.
    Number: -2147217900 (0x80040E14)
    Source: Microsoft JET Database Engine

    webpage: http://madisoncath.web102.discountasp.net/av_catalog.asp
    What am I doing wrong?
     
    bweisse, Jun 3, 2003
    #1
  2. SteveNJ

    SteveNJ

    response.write your query so you know what you are submitting.
    Makes it easier to debug since you can then take the statement and see what's wrong.

    Ex:
    strSQL = "select * from somewhere"
    response.write strSQL
    response.end
     
    SteveNJ, Jun 3, 2003
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    It looks like you are using the FP wizard to generate the data base access page.

    You may want to check with MS FrontPage support regarding this problem. As far as I know, the database access page wizard has a lot of problem.

    quote:Originally posted by bweisse

    Using Frontpage, I had imported an Access db then used the access data wizard in order to view the data. When I went to view the information, I recieved the following error message:
    Database Results Error
    Description: Syntax error in query. Incomplete query clause.
    Number: -2147217900 (0x80040E14)
    Source: Microsoft JET Database Engine

    webpage: http://madisoncath.web102.discountasp.net/av_catalog.asp
    What am I doing wrong?
    </blockquote id="quote"></font id="quote">
     
    Bruce, Jun 4, 2003
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page