autoincrement in access sql is not working
- by Thunder
how can i create a table with autoincrement in access.Here is what i have been doing but not working.
CREATE TABLE People_User_Master(
Id INTEGER primary key AUTOINCREMENT
, Name varchar(50)
, LastName varchar(50)
, Userid varchar(50) unique
, Email varchar(50)
, Phone varchar(50)
, Pw varchar(50)
, fk_Group int
, Address varchar(150)
)