# ASP Microsoft Access Syntax Error when trying to add new record

**URL:** https://forum.kirupa.com/t/asp-microsoft-access-syntax-error-when-trying-to-add-new-record/222537
**Category:** programming
**Created:** [April 14, 2007, 3:30pm UTC](https://forum.kirupa.com/t/asp-microsoft-access-syntax-error-when-trying-to-add-new-record/222537 "2007-04-14T15:30:04Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![woop47](https://avatars.discourse-cdn.com/v4/letter/w/e47774/32.png) [@woop47](https://forum.kirupa.com/u/woop47)
#### Post date: [April 14, 2007, 3:30pm UTC](https://forum.kirupa.com/t/asp-microsoft-access-syntax-error-when-trying-to-add-new-record/222537/1 "2007-04-14T15:30:04Z")

</div>

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]