SQL query syntax error using INSERT INTO

Question

So, I know my code for the database connection and reader is functional, because it has worked for me many times before, however, something about this SQL query: enter image description here gives this error message:

when this data is inputted: enter image description here This is the database table that I am trying to add the data to:

Please copy the sql in your question even if it is in the pictures. In the picture we or you could oversee some charactars or whitespaces. — Andre
– Andre, Commented May 4, 2014 at 10:21

Gord Thompson · Accepted Answer · 2015-02-21 19:43:07Z

2

The issue is that you are using "password" as a column name and that's a reserved word in Jet SQL. Either change the name or escape it in SQL code. You do the latter by wrapping it in square brackets [].

edited Feb 21, 2015 at 19:43

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

answered May 4, 2014 at 10:25

jmcilhinney

54.9k5 gold badges30 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tony Hopkinson Over a year ago

According to this support.microsoft.com/kb/248738 this answer is correct, did you try it?

jmcilhinney Over a year ago

@juergend, you should probably learn something before you speak. An MDB file is a Jet database, plain and simple. Access is an application that was created to provide easy access to Jet databases. More recently, i.e. with Office 2007, the ACCDB file format was created and an ACCDB file can genuinely be called an Access database but, even then, it still supports the same SQL syntax as Jet, although presumably with some additions. If the OP is using an MDB file then they are using a Jet database and therefore Jet SQL. If they're using an ACCDB file then they're still basically using Jet SQL.

Collectives™ on Stack Overflow

SQL query syntax error using INSERT INTO

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related