Error with INSERT and UPDATE

[sbayter]

Hi,
I trying to build a site which has a database behind it.
Everythig is working fine, I can see all the data in the tables from the webpage but I cannot update or insert any new data.
This is the error I am getting:

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

Line 115 is like this:
MM_editCmd.Execute

In other pages I'm getting the same error.
I think this has to do with permissions. I set the permission for IUSR_PC so I don't what is wrong.
Any suggestions?
Thanks,


sbayter

 

[jemminger]

uh, what does your sql statement look like?

=========================================================
try { succeed(); } catch(E) { tryAgain(); }
-jeff

http://www.jeffemminger.com