How to fix an error while working with Access?

Question

Delphi

The code:

DataModule2.ADOQuery1.SQL.Clear; 
DataModule2.ADOQuery1.SQL.Add('INSERT INTO Users ([login],[password]) VALUES ('+Edit1.Text+', '+Edit2.Text+')'); 
DataModule2.ADOQuery1.ExecSQL; 
ShowMessage('Успешно');

Error: "Insert into statement syntax error"
What's wrong?
The table itself has 3 fields: code, login, password

Answer 1

DataModule2.ADOQuery1.SQL.Add('INSERT INTO Users ([login],[password]) VALUES ("'+Edit1.Text+'", "'+Edit2.Text+'")');
The text in the query must be escaped in quotation marks.