Re: Accessing an Access database

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

Date: Fri, 20 Aug 2004 07:25:03 -0700

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: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: How can I create a Remote Access Usage report for my 2003 SBS
    ... Scripts for use with SQL Server are located in a folder on the ISA Server ... You can use these files to create your own log database. ... Microsoft is providing this information as a convenience to you. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)