Error in Update Statement

Hello,

I have an ASP page that needs to update a record, but I keep getting errors,
and cannot see the problem. The error message is:
Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/Cabo/admin/Accomodations/Update.asp, line 112

And the update statement is:

update tblHotels set Name = 'Casa Del Mar Golf Resort & Spa', ListName =
'sdf', Image = '/cabo/accomodations/images/casadelmar.jpg' where HotelID = 1

Can anybody spot the error here? I don't *think* it's a problem with
reserved words, and the field types should all be correct and long enough to
accept the submitted data.

Please help!

--Jon Jaques

Ahhh, never mind, it WAS a problem with Reserved Words!!! What a pain!

Thanks anyhow!

--Jon

"Jon S. Jaques" <jonj.RemoveThis@sysconn.com> wrote in message
news:eYlzwULmDHA.744@tk2msftngp13.phx.gbl...
 > Hello,
 >
 > I have an ASP page that needs to update a record, but I keep getting
errors,
 > and cannot see the problem. The error message is:
 > Microsoft JET Database Engine error '80040e14'
 >
 > Syntax error in UPDATE statement.
 >
 > /Cabo/admin/Accomodations/Update.asp, line 112
 >
 > And the update statement is:
 >
 > update tblHotels set Name = 'Casa Del Mar Golf Resort & Spa', ListName =
 > 'sdf', Image = '/cabo/accomodations/images/casadelmar.jpg' where HotelID =
1
 >
 > Can anybody spot the error here? I don't *think* it's a problem with
 > reserved words, and the field types should all be correct and long enough
to
 > accept the submitted data.
 >
 > Please help!
 >
 > --Jon Jaques
 >
 ><!-- ~MESSAGE_AFTER~ -->