Re: Accessing an Access database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: OKCCowboy (OKCCowboy_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 13:33:01 -0700

OK, so is this a bug in FrontPage or is it something that I have done? If it
is a bug, any idea when/if Microsoft is going to fix it?

"Kathleen Anderson [MVP - FrontPage]" wrote:

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

Relevant Pages

  • Re: Cuts Off Left Side of "W" in Menus - More Bugs in FP 2003?
    ... It doesn't matter whether you use FrontPage, ... other users of Microsoft products. ... As to what you're referring to as a "refresh," it sounds like what you're ... > Want to tell me why that isn't a bug? ...
    (microsoft.public.frontpage.programming)
  • Couldnt Open File Error
    ... I don't remember this happening before, but recently when I have a single htm ... FrontPage I get an error saying "Couldn't Open File ". ... it a bug in FrontPage? ... Is microsoft aware of it? ...
    (microsoft.public.frontpage.client)
  • Re: Cuts Off Left Side of "W" in Menus - More Bugs in FP 2003?
    ... Does Microsoft have a repaired font that could be downloaded? ... > It's not a FrontPage issue, it's a known issue with that particular font. ... Is this another bug in Frontpage? ...
    (microsoft.public.frontpage.programming)
  • Re: WMP 11 Bug
    ... I answered the question and still suggested they seek a response about their problem because it really didn't sound like a bug. ... If there is another means of reporting bugs that I have left off, please feel free to point it out. ... You couldn't really believe that WMP is less simple than say, Vista, or Windows XP, or Microsoft Office, or Internet Explorer. ... Microsoft's behalf that you're having problems with Windows Media Player. ...
    (microsoft.public.windowsmedia)
  • Re: Failed to apply script using osql utility (sp_addscriptexec)
    ... I have been speaking to Microsoft and it turns out this is a bug. ... ch' could not be propagated to the subscriber. ... Repl Agent Status: 6 ...
    (microsoft.public.sqlserver.replication)