OleDB not saved to database file

Question

I have an MDB file I access using OleDB:

OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Database.mdb;Persist Security Info=True");

And try to create a new row in a table Users:

connection.Open();
OleDbCommand cmd = new OleDbCommand("INSERT INTO `users` (`name`, `password`) VALUES ('asd', 'asd')", connection);
cmd.ExecuteNonQuery();
connection.Close();

But nothing happens. I don't get an error message or exceptions, it runs without problems. But when I check the database after the program finished, the table still is empty.

(I already tried the same using DataSets and TableAdapters, but the same happened there: Inserting not committed to database)

Fionnuala · Accepted Answer · 2010-07-27 15:47:18Z

1

That query does not look like an Access query. Have you tried:

"INSERT INTO [users] ([name], [password]) VALUES ('asd', 'asd')"

In Access, table and field names do not use a back-quote, however, reserved words must be enclosed in square brackets.

answered Jul 27, 2010 at 15:47

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

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

Collectives™ on Stack Overflow

OleDB not saved to database file

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