When developing the record insert form in Dreamweaver MX I add an insert record form and select all my fields. However, when I preview the page and submit a test field I receive the following error:


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/bookingnew.asp, line 115

But when I have a smaller form the information is submitted with out a problem.

check out the forms @
bad www.doorhouse.ca/bookingnew.asp
good www.doorhouse.ca/bookingnew2.asp

Post the code of each if you can.

The problem likely lays within your code, not DreamWeaver MX.
Thus I'm with WonderMonkey -- post your code.

I have Dreamweaver MX. If its ASP, as I suspect, check your connections and PWS.

forums.macromedia.com

If your using DW the MM newsgroup will be your best friend ;)