I have had the same troubles as others I have read in this discussion group. Started off by importing an access 2003 database into Front Page 2003. Created a new page and saved it as an .asp. Ran the database results wizard, used the correct database connection, tried to use an existing access query (View), and got "database results wizard failed. Contact your......" error. Then, after reading some posts on this board, changed the fpclass file "debug=false" to "true. Also tried establishing defaults for all fields in the wizard but, the wizard won't let me select defaults so I added a default to all fields directly in Access. After that, I got "syntax error". Read another post and tried to create a custom query instead of an existing access query. Still the same error. HELP !!!

JohnP,

It sounds menial but have you checked with your Hosting Service to
ensure they support Access Databases and the Access Web View portion of
Access Databases? I know one of the Hosting Services I use currently states
they support Access DB's but don't support the Access Web View portion
(which thoroughly ****es me off and is the main reason I am dumping them
come re-up time). So in short...check with your provider to ensure they are
capable of supporting what you are trying to do.

Good Luck,
Carl

"JohnP" <(E-Mail Removed)> wrote in message
news:85D6C96B-4876-4DDA-9C78-(E-Mail Removed)...
> I have had the same troubles as others I have read in this discussion
group. Started off by importing an access 2003 database into Front Page
2003. Created a new page and saved it as an .asp. Ran the database results
wizard, used the correct database connection, tried to use an existing
access query (View), and got "database results wizard failed. Contact
your......" error. Then, after reading some posts on this board, changed
the fpclass file "debug=false" to "true. Also tried establishing defaults
for all fields in the wizard but, the wizard won't let me select defaults so
I added a default to all fields directly in Access. After that, I got
"syntax error". Read another post and tried to create a custom query
instead of an existing access query. Still the same error. HELP !!!

Steve,

Did you tried in the custom query changing all the ""
with [ ]

Also try using table and field names without '-' eg: fiel-name (use
fieldname )

binu

-------------------------------------------------------------

| JohnP,
|
| It sounds menial but have you checked with your Hosting Service to
| ensure they support Access Databases and the Access Web View portion of
| Access Databases? I know one of the Hosting Services I use currently
states
| they support Access DB's but don't support the Access Web View portion
| (which thoroughly ****es me off and is the main reason I am dumping them
| come re-up time). So in short...check with your provider to ensure they
are
| capable of supporting what you are trying to do.
|
| Good Luck,
| Carl
|
| "JohnP" <(E-Mail Removed)> wrote in message
| news:85D6C96B-4876-4DDA-9C78-(E-Mail Removed)...
| > I have had the same troubles as others I have read in this discussion
| group. Started off by importing an access 2003 database into Front Page
| 2003. Created a new page and saved it as an .asp. Ran the database
results
| wizard, used the correct database connection, tried to use an existing
| access query (View), and got "database results wizard failed. Contact
| your......" error. Then, after reading some posts on this board, changed
| the fpclass file "debug=false" to "true. Also tried establishing defaults
| for all fields in the wizard but, the wizard won't let me select defaults
so
| I added a default to all fields directly in Access. After that, I got
| "syntax error". Read another post and tried to create a custom query
| instead of an existing access query. Still the same error. HELP !!!
|
|
|

I am using myhosting.com. They supposedly support it all --- frontpage extensions, sharepoint, etc.. They even give me one DSN for my access database as part of the package. And yes, the DSN I registered with them is identical to the database name in the fdpb folder. Any other thoughts???

No field names with a dash but, I will try the [] instead of "" and let you know.

Whats the actual error you receive and for what SQL string?

"John" <(E-Mail Removed)> wrote in message
news:7F11BCFA-3E14-4831-BC1B-(E-Mail Removed)...
> I am using myhosting.com. They supposedly support it all --- frontpage
extensions, sharepoint, etc.. They even give me one DSN for my access
database as part of the package. And yes, the DSN I registered with them is
identical to the database name in the fdpb folder. Any other thoughts???

The exact error i

Database Results Wizard Erro
Description: Syntax error in query. Incomplete query clause
Number: -2147217900 (0x80040E14
Source: Microsoft JET Database Engin

Post the query

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"John" <(E-Mail Removed)> wrote in message
news:19D73380-D2AC-4E8E-9D98-(E-Mail Removed)...
> The exact error is
>
> Database Results Wizard Error
> Description: Syntax error in query. Incomplete query clause.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft JET Database Engine
>

Seems like I fixed it after reading another post on this board. You need to do a custom query and change the "" to []