[Lazarus] create table doesn't store

[Larry Dalton]

Using Lazarus 2.2 ORC1-fpc-e.w.w-win64,
Windows 11
Microsoft Access 64 bit
procedure TAccess_form.ExcelTestButtonClick(Sender: TObject);
var create_string:string;
begin
 ExcelTestQuery.Close;
 ExcelTestQuery.SQL.Clear;
 create_string:='CREATE TABLE TEST_TABLE';
 ExcelTestQuery.SQL.Append(create_string);
 create_string:='[CUSTOMER STRING(40)]';
 ExcelTestQuery.SQL.Append(create_string);
 Memo1.Lines:=ExcelTestQuery.SQL;
 ExcelTestQuery.ExecSQL;

end;

This code says it creates TEST_TABLE, but it doesn't store it in the
database.
If I click the button once, it apparently creates the table.
If I then click it the second time, it gives me an error code that the
table exists.
If I close the application and look in the database, it doesn't exist.
Then if I open the application again,it lets me create it again.
Why is it not storing the table in the database?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20230209/ea63a4d6/attachment.htm>