Hi im adding a new table to my existing DB and auto insert record from DMX and im getting the following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/rockvisuals/TMPatsve62sr.asp, line 115

All other tables are fine... updates are working, displaying etc. Only when i add a new table <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> ??


Edited by - Tmx on 30 Apr 2003 22:35:39

Edited by - Tmx on 02 May 2003 04:25:22

I should have added that I can display the same table if add records manually to the DB, it just wont update anymore.

Thanks

has anyone any idea what this could be before i reluctantly reinstall... ive tried new dsn connection/databases and still the same problem.... PLEASE PLEASE HELP, i got a deadline...<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Well

are you getting the same problem with other sites? maybe set up a new test site / connection. If the problem affects other sites then you have isolated the problem to the application server.

although it seems like it's a coding problem.

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

I tried everything Julio and it didnt help but I did work out what it was.

Reasons to cause this error:
Using a "reserved word" as a name. Most databases have a set of "reserved words" which have meaning to the database engine because they may be used to identify built-in functions or keywords. For example, "date" is a reserved word and cannot be used for column names in the database.

I had one of my fields named Date for each table it didnt work with.

Thanks for your help tho.