Professional Web Applications Themes

Error accesing access via query created in FrontPage - ASP Database

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...

  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. #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" <agrab747hotmail.com> wrote in message
    news:152501c46f2b$5a4625c0$a501280aphx.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

  3. #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" <agrab747hotmail.com> wrote in message
    >news:152501c46f2b$5a4625c0$a501280aphx.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

Similar Threads

  1. Replies: 6
    Last Post: September 2nd, 01:22 PM
  2. Error Executing Access Database Query
    By kschock in forum Coldfusion Database Access
    Replies: 2
    Last Post: April 18th, 09:54 PM
  3. Replies: 1
    Last Post: August 10th, 12:41 PM
  4. How can i upload a web created in frontpage to a folder
    By me_myself_and_I in forum Web Design
    Replies: 1
    Last Post: January 12th, 02:57 PM
  5. JET error '80040e10' from Access 2000 query
    By Noral Kuhlmann in forum ASP Database
    Replies: 4
    Last Post: November 18th, 04:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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