MS Access INSERT INTO statement

ms-access

Solution

I believe `date` is a reserved word. You need to encapsulate the reserved field names in square brackets:

`INSERT INTO bs1 (teacher, subject, [date], period) VALUES ('test', 'test', 'test', 'test')`

EDIT: See the following article for a complete list of reserved words in Access 2002 and greater: http://support.microsoft.com/kb/286335

~md5sum~

Problem

I need to insert form data from my VB.NET application to a Microsoft Access database. I am getting the error `"Syntax error in INSERT INTO statement"` when using the following syntax: ``` INSERT INTO bs1 (teacher, subject, date, period) VALUES ('test', 'test', 'test', 'test') ``` I'll admit I'm used to the MySQL type syntax, any help on this matter would be greatly appreciated, thanks.

Original source