Software untuk membuat : visual studio 2008
Database : Microsoft Access 2010

Coding :
public void InsertUser(string userID, string password, string active, string name, string userType, IDbConnection conn)
{
int i;

try
{
sb = new StringBuilder();
comm = new OleDbCommand();

comm.Connection = conn;

sb.Append(@"INSERT INTO MASTER_USER (USER_ID, PASSWORD, IS_ACTIVE, NAME, USER_TYPE) VALUES('");
sb.Append(userID);
sb.Append("', '");
sb.Append(password);
sb.Append("', '");
sb.Append(active);
sb.Append("', '");
sb.Append(name);
sb.Append("', '");
sb.Append(userType);
sb.Append("')");
comm.CommandText = sb.ToString();

i = comm.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception("Failed to execute insert on data access layer", ex);
}
}

pesan yang muncul : syntax error in insert into statement

Saya coba debug, saya dapat nilai sb = {INSERT INTO MASTER_USER (USER_ID, PASSWORD, IS_ACTIVE, NAME, USER_TYPE) VALUES('oke', 'oke', '1', 'oke', 'NU')}

saya coba execute nilai sb langsung di access dan bisa
tapi kalau melalui program tidak bisa

mohon bantuannya