Re: Accessing an Access database
From: Kathleen Anderson [MVP - FrontPage] (spiderwebwoman_at_mvps.org)
Date: 08/20/04
- Next message: Ronx: "Re: How do I set up and publish a subdomain"
- Previous message: Tom Pepper Willett: "Re: How do I set up and publish a subdomain"
- In reply to: OKCCowboy: "Re: Accessing an Access database"
- Next in thread: OKCCowboy: "Re: Accessing an Access database"
- Reply: OKCCowboy: "Re: Accessing an Access database"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Aug 2004 10:48:42 -0400
OKCCowboy:
Try putting brackets around Advisory Members: [Advisory Members]
-- ~ Kathleen Anderson Microsoft FrontPage MVP Spider Web Woman Designs http://www.spiderwebwoman.com/resources/ OKCCowboy <OKCCowboy@discussions.microsoft.com> wrote: > OK, I did what you suggested and got the following: > > Database Results Wizard Error > Description: Syntax error in query. Incomplete query clause. > Number: -2147217900 (0x80040E14) > Source: Microsoft JET Database Engine > > Additionally, here is what FrontPage generated: > > fp_sQry="SELECT * FROM ""Advisory Members"" ORDER BY Committee > ASC,""Last Name"" ASC,""First Name"" ASC" > fp_sDefault="" > fp_sNoRecords="No records returned." > fp_sDataConn="AdvisoryMembers" > fp_iMaxRecords=0 > fp_iCommandType=1 > fp_iPageSize=0 > fp_fTableFormat=False > fp_fMenuFormat=False > fp_sMenuChoice="Title" > fp_sMenuValue="Title" > fp_sColTypes="&Title=202&First Name=202&Last Name=202&Job > Title=202&Company=202&Address=202&City=202&State=202&Zip > Code=202&Phone Number=202&E-Mail Address=202&Committee=202&" > fp_iDisplayCols=12 > fp_fCustomQuery=False > BOTID=0 > fp_iRegion=BOTID > > > "Kathleen Anderson [MVP - FP]" wrote: > >> The FP2003 code has changed slightly. To see the true error, open >> the hidden folder /_fpclass/ and edit the fpdbrgn1.inc file >> >> At about line 19, change : >> >> fp_DEBUG = False >> >> to : >> >> fp_DEBUG = True >> >> >> -- >> ~ Kathleen Anderson >> Microsoft MVP - FrontPage >> Spider Web Woman Designs >> http://www.spiderwebwoman.com/resources/ >> >> >> OKCCowboy <OKCCowboy@discussions.microsoft.com> wrote: >>> I have a web page that seems to have major problems. I can use the >>> FrontPage tools to access the database at design time, but after I >>> publish the page I get the following message: >>> "Database Results Wizard Error >>> The operation failed. If this continues, please contact your server >>> administrator" >>> >>> Well, I AM the server admin. We are using FP 2003, IIS 2000, FP >>> Extenstions and sharepoint. ALL the other access databases work. >>> They were designed and published with FP 2002. Does FP 2003 have a >>> problem?
- Next message: Ronx: "Re: How do I set up and publish a subdomain"
- Previous message: Tom Pepper Willett: "Re: How do I set up and publish a subdomain"
- In reply to: OKCCowboy: "Re: Accessing an Access database"
- Next in thread: OKCCowboy: "Re: Accessing an Access database"
- Reply: OKCCowboy: "Re: Accessing an Access database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
