I've been trying to insert a record into an Access database.
I have tried to use the Record Insertion Form and also tried it by making the insert record page block by block. However, every time I preview the page in my browser and press Submit after entering information in the fields, I get an error which says, Microsoft JET Database Engine error '80040e14' "Synatx error in INSERT INTO statement" and the code in question is "MM_editCmd.Execute".
Could someone please guide me thru the steps of making a simple record insertion page and also the settings involved.
Thanks in advance.

Edited by - mmb215 on 07 May 2003 01:29:04