Ask a Question related to ASP Database, Design and Development.
-
Andrew #1
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
-
[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... -
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'. ... -
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... -
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... -
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... -
Ray at #2
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
-
Andrew #3
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
to see your code,>-----Original Message-----
>I'm hesitant to ask this of Frontpage code, but we'd needyou can, the output>specifically that which creates the SQL string. And ifoutstanding.>of RESPONSE.WRITE TheVariableWithTheSQLQuery would beIIS>
>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>>> 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



Reply With Quote

