Access database reserved words for the most careful use

Today has been looking for solutions to the following errors, the final method surprised me Ah, I spent an afternoon, whining ....

A simple INSERT statement like the following, always prompt the following error,

It is also OK to put the statement in the Access background database, no problem, normal can be inserted.

Insert into Member (Companyname,address,email,phone,person,audit,Password, CreateDate) VALUES (@CompanyName , @Address, @Email, @Phone, @Person, @Audit, @Password, @CreateDate)

If the suspicion is the Oledbhelper class has a problem, but the other words of the insertion is possible ah, in the online search for a lot of stickers, did not say the point on, just a sudden search to a netizen said access to the reserved word with the need for brackets , if suddenly.

If you change the statement to read as follows:

Insert into Member (Companyname,address,email,phone,person,audit, [Password], CreateDate) VALUES (@ CompanyName, @Address, @Email, @Phone, @Person, @Audit, @Password, @CreateDate)

Successful execution!

Access database reserved words for the most careful use