title: INSERT INTO statement for Access in ASP.NET
body: <p>I am developing a website.</p>
  
  <p>My connection string in web.config is as below:</p>
  
  <pre><code>"add name="MyDbConn1" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\QWIN 2000Q\Database\qwin_5501q.mdb;""
  </code></pre>
  
  <p>I already retrieve several times from that database using that connection string. They are working.</p>
  
  <p>But When I insert into a table, error pop ups that "syntax error in INSERT INTO statement".</p>
  
  <p>The below is my codes for insert into statement.</p>
  
  <pre><code>command2.Parameters.AddWithValue("@Name", txtUser.Text);
  command2.Parameters.AddWithValue("@Password", txtPwd.Text);
  command2.Parameters.AddWithValue("@Role", ddlAccess.SelectedItem.ToString());
  string abc = "Insert into Report_User (Name, Password, Role) VALUES (@Name,@Password,@Role);";
  </code></pre>
  
  <p>When I run that statement in the Microsoft Access, there is no error.</p>
  
  <p>Anyone?</p>
  
  <p>Is there any folder sharing permission or some sort??</p>