How do I write an Microsoft Access SQL Query in C#?

I'm trying to run this Microsoft Access query in C#, but it isn't working:

Cre开发者_StackOverflow社区ate table Users (UserName Text(50) Primary Key, Password Text(50), IsLocked YESNO)

I get a Syntax error in field definition error.

How do I write a Microsoft Access SQL Query in C#?

Try this:

Create Table [Users] ([UserName] Text(50) Primary Key, [Password] Text(50), [IsLocked] YESNO)