Re: Access and Front Page 2003 -- Syntax Error

From: Binu K (binuk_at_online.microsoft.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 03:18:50 GMT

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
|
| "JohnP" <anonymous@discussions.microsoft.com> wrote in message
| news:85D6C96B-4876-4DDA-9C78-236BBB98B94A@microsoft.com...
| > 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 !!!
|
|
|

Relevant Pages

  • Re: Access and Front Page 2003 -- Syntax Error
    ... they support Access DB's but don't support the Access Web View portion ... Started off by importing an access 2003 database into Front Page ... and got "database results wizard failed. ...
    (microsoft.public.frontpage.client)
  • Re: Can FP Handle Complex Queries
    ... While using the FP Database Results Wizard to set up the custom query, ...
    (microsoft.public.frontpage.programming)
  • Database interface Wizard
    ... You can do a view query, it will show up on the database ... Try a custom query if you want the timestamp field, ... >But the wizard won't allow the creation of interface ...
    (microsoft.public.frontpage.programming)
  • Custom Query Size Limit in FP 2000
    ... FP 2000 seems to have a size limit on placing large SQL ... Statements into the Custom Query box in the Database ... Results wizard. ...
    (microsoft.public.frontpage.client)
  • Re: DBRW generating ADODB.Command error 800a0cc1
    ... Off topic - the formula you are using for max and min Longitude is accurate only at the equator. ... Ron Symonds ... > Database Results Wizard Error ... >> Don't place the code in the custom query. ...
    (microsoft.public.frontpage.programming)