Using the database Results wizard in Frontpage I have set up a database
editor page but get a database connection error when I verify the criteria:
Server error: Unable to retrieve schema information from the query:

UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website =
'4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' , Area =
'9' , Salary = '10' , Per = '11' , Description = '12' , Remote_computer_name
= '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17' ,
Browser_type = '18' WHERE (ID = 19)


The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

This is the SQL statement:


UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' , Contact
= '::Contact::' , Website = '::Website::' , Email = '::Email::' , Telephone =
'::Telephone::' , Address = '::Address::' , Position = '::Position::' , Area
= '::Area::' , Salary = '::Salary::' , Per = '::Per::' , Description =
':escription::' , Remote_computer_name = '::Remote_computer_name::' ,
Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' ,
User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID =
::ID:

I would appreciate your help!

Anna Mac

Anna Mac:
What version of FrontPage are you running? If FP2003, have you applied all
Office Service Packs?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




"annaMac" <(E-Mail Removed)> wrote in message
news:15279768-CE08-41CE-A93B-(E-Mail Removed)...
> Using the database Results wizard in Frontpage I have set up a database
> editor page but get a database connection error when I verify the
> criteria:
> Server error: Unable to retrieve schema information from the query:
>
> UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website
> =
> '4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' ,
> Area =
> '9' , Salary = '10' , Per = '11' , Description = '12' ,
> Remote_computer_name
> = '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17'
> ,
> Browser_type = '18' WHERE (ID = 19)
>
>
> The following error message comes from the database driver software; it
> may
> appear in a different language depending on how the driver is configured.
> -------------------------------------------------------
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
> statement.
>
> Source: Microsoft OLE DB Provider for ODBC Drivers
> Number: -2147217900 (0x80040e14)
>
> This is the SQL statement:
>
>
> UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' ,
> Contact
> = '::Contact::' , Website = '::Website::' , Email = '::Email::' ,
> Telephone =
> '::Telephone::' , Address = '::Address::' , Position = '::Position::' ,
> Area
> = '::Area::' , Salary = '::Salary::' , Per = '::Per::' , Description =
> ':escription::' , Remote_computer_name = '::Remote_computer_name::' ,
> Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' ,
> User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID
> =
> ::ID:
>
> I would appreciate your help!
>
> Anna Mac

Kathleen, its 2003 with service pack 2 . I have solved the problem though,
thanks - Timestamp is a reserved name so I just had to bracket it and then
set any empty fields to zero length. It works fine now.

"Kathleen Anderson [MVP - FrontPage]" wrote:

> Anna Mac:
> What version of FrontPage are you running? If FP2003, have you applied all
> Office Service Packs?
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
> FrontPage Support: http://www.frontpagemvps.com/
>
>
>
>
> "annaMac" <(E-Mail Removed)> wrote in message
> news:15279768-CE08-41CE-A93B-(E-Mail Removed)...
> > Using the database Results wizard in Frontpage I have set up a database
> > editor page but get a database connection error when I verify the
> > criteria:
> > Server error: Unable to retrieve schema information from the query:
> >
> > UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website
> > =
> > '4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' ,
> > Area =
> > '9' , Salary = '10' , Per = '11' , Description = '12' ,
> > Remote_computer_name
> > = '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17'
> > ,
> > Browser_type = '18' WHERE (ID = 19)
> >
> >
> > The following error message comes from the database driver software; it
> > may
> > appear in a different language depending on how the driver is configured.
> > -------------------------------------------------------
> > [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
> > statement.
> >
> > Source: Microsoft OLE DB Provider for ODBC Drivers
> > Number: -2147217900 (0x80040e14)
> >
> > This is the SQL statement:
> >
> >
> > UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' ,
> > Contact
> > = '::Contact::' , Website = '::Website::' , Email = '::Email::' ,
> > Telephone =
> > '::Telephone::' , Address = '::Address::' , Position = '::Position::' ,
> > Area
> > = '::Area::' , Salary = '::Salary::' , Per = '::Per::' , Description =
> > ':escription::' , Remote_computer_name = '::Remote_computer_name::' ,
> > Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' ,
> > User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID
> > =
> > ::ID:
> >
> > I would appreciate your help!
> >
> > Anna Mac
>
>
>