使用C#操作ACCESS数据库时提示 “FORM子句语法错误”。

C#操作ACCESS数据库时提示 “FORM子句语法错误

错误提示和代码原文如图所示

 OleDbConnection oleDbConnection = new OleDbConnection();
oleDbConnection.ConnectionString = string.Format(@" Provider = Microsoft.ACE.OLEDB.12.0; Data Source = {0}; Jet OLEDB:Database Password = {1}", path,"admin");
        OleDbCommand oleDbCommand = new OleDbCommand();
        oleDbCommand.Connection = oleDbConnection;
        oleDbCommand.CommandText= "select*from [User];";
        oleDbConnection.Open();
        OleDbDataReader oleDbDataReader= oleDbCommand.ExecuteReader();
        if (oleDbDataReader.HasRows)
        {
            while (oleDbDataReader.Read())
            {
                for (int i = 0; i < oleDbDataReader.FieldCount - 1; i++)
                {
                    if (!oleDbDataReader.IsDBNull(i))
                    {
                        listBox1.Items.Add(oleDbDataReader.GetString(i));
                    }                   
                }
            }         
        }

以上为修改后的代码可以正常查询
造成这个问题的原因是“User”是SQL的保留字增加"[ ]"号后可解除此类错误；
为自己的错误做记录