Error Message when using insert record form 1

[smurf01]

Hi can anyone help me, I have created an insert record form however whenever i click on the submit button i get the following error mesage and i cannot see what i am doing wrong. I have also created an update record form and this works fine using the same table in the same database

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

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

/MCTestInsert.asp, line 115


Regards

Paul

 

[bluranj]

http://www.macromedia.com/support/ultradev/ts/documents/insert_into.htm

Ranjan

http://www.dreamlettes.com

- A Dreamweaver Community
Join today for your answers in web design

 

[CTekMedia]

That error message provides little information. Just keeping picking at it - like a puzzle you will see the answer. If you have to, delete the behavior, make sure your html is clean, then redo the behavior. Look for data mismatches between your database and the insert form (too long, wrong type, null values not accepted etc.).

Make sure your field names match between your page and the DB - or at least that they are connected properly.

Merry Christmas Peace

http://www.bluetone.biz

BT

 

[schase]

Ranj is correct - it is a case of reserved name fields. "Never underestimate the power of determination"

Stuart

 

[CTekMedia]

Ok, that error message provides lots of information lol. Peace

http://www.bluetone.biz

BT

 

[schase]

lol your right - it really doesnt at all.

I've just been there sooooooooo many times.

"Never underestimate the power of determination"

Stuart