How to add data to an Access database?

Question

Delphi

I'm trying to add a new user to the database in the following way:

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

But it gives the error "...Syntax error (operator missing) in query expression"
What's wrong?
The table itself has 3 fields: code, Login, password

Answer 1

Good. Well, there's nothing to think about. Actually a syntax error, most likely with '
Take this all 'INSERT INTO Users (login,password) VALUES ('''+Edit1.Text+''', '''+Edit2.Text+''')');
DataModule2.ADOQuery1.ExecSQL;
Drive it into a text variable along with the data, you'll see for yourself. If you don't see it, display it in Management Studio

Answer 2

Can count first:

now the error is "syntax error of insert into statement"

Check the query text (SQL.Text) either with a debugger or ShowMessage.