I have built a database editor using the database interface wizard. However,
when I attempt to use the editor I get a database results error. I
re-entered the database results section of update.asp (which was built by the
database interface wizard) and attempted to verify the query and got the
following message

Server error: Unable to retrieve schema information from the query:

UPDATE Events SET Event = '1' , EventSeries = '2' , EventType = '3' ,
Headliner = '4' , Supporting = '5' , Venue = '6' , Date = '7' , Time = '8' ,
MoreInfoOnEvent = '9' , TicketsRequired = '10' , AdmissionFee = '11' ,
TicketsInfo = '12' , VenueDataSource = '13' , ProgramSummary = '14' WHERE
(ID = 15)

against a database using the connection s

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)


I have two other database editors running against different tables in the
same access database and they all run add/change/delete without problems.

The database editor works for add/delete in this particular table, but the
change capability does not seem to work for some reason. There have been no
changes to the code generated by the database interface wizard except to flag
the field id as autonumber (it is the primary key).

I have contacted my server host and they tell me that everything is
correctly configured on their end.

Can anyone point me in the right direction to resolve this problem?

Date & Time are resevered keywords.
http://sqlserver2000.databases.aspfa...-keywords.html

Bob Lehmann

"Bob" <(E-Mail Removed)> wrote in message
news:0D7DAEB9-2209-4C97-A6BD-(E-Mail Removed)...
> I have built a database editor using the database interface wizard.
However,
> when I attempt to use the editor I get a database results error. I
> re-entered the database results section of update.asp (which was built by
the
> database interface wizard) and attempted to verify the query and got the
> following message
>
> Server error: Unable to retrieve schema information from the query:
>
> UPDATE Events SET Event = '1' , EventSeries = '2' , EventType = '3' ,
> Headliner = '4' , Supporting = '5' , Venue = '6' , Date = '7' , Time = '8'
,
> MoreInfoOnEvent = '9' , TicketsRequired = '10' , AdmissionFee = '11' ,
> TicketsInfo = '12' , VenueDataSource = '13' , ProgramSummary = '14' WHERE
> (ID = 15)
>
> against a database using the connection s
>
> 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)
>
>
> I have two other database editors running against different tables in the
> same access database and they all run add/change/delete without problems.
>
> The database editor works for add/delete in this particular table, but the
> change capability does not seem to work for some reason. There have been
no
> changes to the code generated by the database interface wizard except to
flag
> the field id as autonumber (it is the primary key).
>
> I have contacted my server host and they tell me that everything is
> correctly configured on their end.
>
> Can anyone point me in the right direction to resolve this problem?
>
>