Syntax error in INSERT INTO statement.

Thanks to everyone for the helpful replies. It turns out that machine (where I was able to work successfully) has IIS set up to run ASP.net version 1.1.4322 and machine 2 (where I was having problems) had IIS set up to run ASP.net version 2.0.50727. I changed the version and now everything works successfully.

If it works on one machine and not the other then check that you do not use
the word "Password" for a field name. This seems to have been added to the
list or reserved words.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"NewDevGuy" <webforumsuser@macromedia.com> wrote in message
news:f6grp2$lt3$1@forums.macromedia.com...
> Hi everyone,
>
> I'm developing a form in DWMX using ASP VBScript trying to write to an
> Access
> db
>
> I've done similar things successfully on another PC and remember having to
> go
> through various file permissions tweaks before I could successfully write
> to
> the db. I've compared the security/file folder permissions of both
> machines
> and made a few changes to make the second PC set up the same as the one
> I've
> worked on successfully.
>
> At this point, I'm just trying to write the value of a text field to the
> db
> and get an "HTTP 500.100 - Internal Server Error - ASP error" -
> specifically"Syntax error in INSERT INTO statement.".
>
> I can copy the pages to the other machine and write the value successfully
> so
> it must be some permissions or other setting on the second machine. Any
> ideas?
>
> Thanks.
>

The error generally means that you are using a reserved word for the name of
a field. eg Date

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004