I am working with MS-Access and JSP. I want to know that how can we create table with autonumber field and with primary key.

> 
> query="Create Table Registration\_A (Reg\_No PRIMARY KEY AUTOINCREMENT,
>  FName varchar(2))";
> 
> 
> 

But its giving syntax error. What's the correct syntax?