Hi. I am using dreamweaver and and access database.

I have sucessfully created a login page etc...

However i now wish to create a page which can insert data into the database. I used dreamweaver to generate the code for this. When previewing the page i recive a error of the following form:

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/regis.asp, line 99


The line of code on that line is as follows:

96 Set MM_editCmd = Server.CreateObject("ADODB.Command")
97 MM_editCmd.ActiveConnection = MM_editConnection
98 MM_editCmd.CommandText = MM_editQuery
99 MM_editCmd.Execute
100 MM_editCmd.ActiveConnection.Close

Has any one got any ideas why it is erroring like this. Thanks

Where did you put the value inside MM_editQuery variable? Please post from there.

Khurram.