Access and Front Page 2003 -- Syntax Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 pisses 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 said:
I have had the same troubles as others I have read in this discussion
Click to expand...
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 pisses 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
|
| | > 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???
 
Whats the actual error you receive and for what SQL string?

John said:
I am using myhosting.com. They supposedly support it all --- frontpage
Click to expand...
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)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Seems like I fixed it after reading another post on this board. You need to do a custom query and change the "" to []
 
Back
Top