title: I have a syntax error in my insert into statement
body: <p>I'm using a MS Access database, with the following columns in the <code>Admins</code> table:</p>
  
  <pre><code>Column        Type
  ======        ====
  Name          Text 
  Surname       Text 
  Dateadded     Date/time 
  Adminnumber   Number(long integer) 
  Password      Text 
  ID type       Autonumber  (Not sure if ID is relevant) 
  </code></pre>
  
  <p>This is my code but it keeps giving me a syntax error. </p>
  
  <pre><code>ADOquery1.Active := false;
  adoquery1.sql.Text := 'insert into Admins(Name, surname, Adminnumber, Dateadded,password)Values('''+edit11.Text+''', '''+edit12.text+''', '''+edit13.Text+''', '''+edit14.Text+''', '''+edit15.text+''')';
  ADOquery1.ExecSQL;
  Adoquery1.SQL.Text := 'select * from Admins';
  ADOquery1.Active := true;
  </code></pre>
  
  <p>i have been trying for a day to figure it out but its the same error no matter what code i use. The error is</p>
  
  <blockquote>
    <p>Project project1.exe raised exception class eoleException 
        with message 'Syntax error in INSERT INTO statement'.</p>
  </blockquote>
  
  <p>i have also tried:</p>
  
  <pre><code>ADOquery1.SQL.Add('Insert into admins');
  ADOquery1.SQL.Add('(Name , Surname, Dateadded, Adminnumber, Password)');  
  ADOquery1.SQL.Add('Values :Name, :Surname, :Dateadded, :adminnumber :Password)');
  ADOquery1.Parameters.ParamByName('Name').Value := edit11.Text;
  ADOquery1.Parameters.ParamByName('Surname').Value := edit12.Text;
  ADOquery1.Parameters.ParamByName('Dateadded').Value := edit13.Text;
  ADOquery1.Parameters.ParamByName('Password').Value := edit14.Text;
  ADOquery1.Parameters.ParamByName('Adminnumber').Value := edit15.Text;
  ADOquery1.ExecSQL;
  ADOquery1.SQL.Text := 'Select * from admins';
  ADOquery1.Open ;
  </code></pre>
  
  <p>But this code gives me a problem with the from clause</p>