error while accessing database using insert into statement in C#

Question

I am facing same problem as this one.only problem is that i am having the fields as follows

Field Name     Data
-------------------
ID             AutoNumber
username       Text
password       Text

now I don't know if any of the word username,password is keyword in ODBC.
I googled for it and many anwsers says the none of it is keyword in ODBC.
I am using ms access.
Can anyone help me?

this one link faced more problem. So, can you tell your problem one by one. — Mohd Sadham
– Mohd Sadham, Commented Apr 18, 2014 at 5:05
@UdanPirappu when i try to execute insert into Users values(1,'nikhil','mehta') it works fine form C#.but insert into Users(username,password) values('nikhil','mehta') gives syntax error in insert into statement and it works fine in ms access — nikhil mehta
– nikhil mehta, Commented Apr 18, 2014 at 5:09
But, In SQLite your code worked. In SQLite, I set some option for ID Field such as NOT NULL, PRIMARY KEY, AUTOINCREMENT, UNIQUE, DEFAULT 1. Likewise, may be you put some option for your ID field. — Mohd Sadham
– Mohd Sadham, Commented Apr 18, 2014 at 5:28
@UdanPirappu i have tried may ways to do it but gives same error.Can you tell me if there any issue while accessing ms acces databse outside of ms access i.e. programatically. — nikhil mehta
– nikhil mehta, Commented Apr 18, 2014 at 5:33

Mohd Sadham · Accepted Answer · 2014-04-18 06:31:47Z

1

Password is a reserved word. Bracket that field name to avoid confusing the db engine.

Insert into Users (Username, [Password]) values ('nikhil','mehta');

answered Apr 18, 2014 at 6:31

Mohd Sadham

4354 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

error while accessing database using insert into statement in C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related