Error accesing access via query created in FrontPage

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Error accesing access via query created in FrontPage

    After I run IIS lockown on windows 2000 standard with IIS
    5.0. My website - built using FrontePage is getting the
    following error when accessing access databse

    Description: Syntax error in query. Incomplete query
    clause.
    Number: -2147217900 (0x80040E14)
    Source: Microsoft JET Database Engine

    Please advise - thanks for your help - Andrew

    Andrew Guest

  2. Similar Questions and Discussions

    1. [microsoft][odbc microsoft access driver] syntax error (missing operator) in query expression error
      I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when...
    2. Error Executing Access Database Query
      The query works in 5, chokes in MX7 Error Message: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. ...
    3. adding a hyperlink to a field in a table created from a d/b query (Access)
      I've done this using Frontpage; and I know I've done it in the past using just ASP. I'm trying to stay away from FP on this site, so.... Can...
    4. How can i upload a web created in frontpage to a folder
      what i mean is, rather than uploading to www.myname.freeserve.co.uk i want to able to upload to a folder ie www.myname.freeserve.co.uk/folder1 Is...
    5. JET error '80040e10' from Access 2000 query
      I wrote this query in Access 2000 the query has no parameters, however when I run it on IIS 5.0 it flakes out. Here is the code: 07 Set Postings...
  3. #2

    Default Re: Error accesing access via query created in FrontPage

    I'm hesitant to ask this of Frontpage code, but we'd need to see your code,
    specifically that which creates the SQL string. And if you can, the output
    of RESPONSE.WRITE TheVariableWithTheSQLQuery would be outstanding.

    Ray at work

    "Andrew" <agrab747@hotmail.com> wrote in message
    news:152501c46f2b$5a4625c0$a501280a@phx.gbl...
    > After I run IIS lockown on windows 2000 standard with IIS
    > 5.0. My website - built using FrontePage is getting the
    > following error when accessing access databse
    >
    > Description: Syntax error in query. Incomplete query
    > clause.
    > Number: -2147217900 (0x80040E14)
    > Source: Microsoft JET Database Engine
    >
    > Please advise - thanks for your help - Andrew
    >

    Ray at Guest

  4. #3

    Default Re: Error accesing access via query created in FrontPage

    I have found the solution. My FP extention were corrupted
    and I had to repbulish the website. After that all works
    fine. Thanks - Andrew
    >-----Original Message-----
    >I'm hesitant to ask this of Frontpage code, but we'd need
    to see your code,
    >specifically that which creates the SQL string. And if
    you can, the output
    >of RESPONSE.WRITE TheVariableWithTheSQLQuery would be
    outstanding.
    >
    >Ray at work
    >
    >"Andrew" <agrab747@hotmail.com> wrote in message
    >news:152501c46f2b$5a4625c0$a501280a@phx.gbl...
    >> After I run IIS lockown on windows 2000 standard with
    IIS
    >> 5.0. My website - built using FrontePage is getting the
    >> following error when accessing access databse
    >>
    >> Description: Syntax error in query. Incomplete query
    >> clause.
    >> Number: -2147217900 (0x80040E14)
    >> Source: Microsoft JET Database Engine
    >>
    >> Please advise - thanks for your help - Andrew
    >>
    >
    >
    >.
    >
    Andrew Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139