Access Error: sytax error in query

[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?

[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

[bruce]

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.

[b]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">