I am currently using Dreamweaver to produce a asp and vbscript page with an Access database to create a small project. I have been able to update records in various other table no problem, but this one particular table has been causing me bother. The table in Microsoft Access is OK , all the variables being passed through are being sent through as the corect data type. But still no matter what way I add a Record Insertion form to update any of these feilds it throws up the error
“[COLOR=#000000][FONT=verdana]Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
**/project/Admin/addnewdoc3.asp, line 135”
**If anyone can can help this would be most appreciated, as i have spent many hours redoing this page, redoing the database, inserting records into each field individually (which strangley is very tempermental). If anyone can gelp or has any idea i can provide snippets of code where required.
Thanks for your time.
[/FONT][/COLOR]
