autoincrement in access sql is not working

Posted by Thunder on Stack Overflow See other posts from Stack Overflow or by Thunder
Published on 2010-04-13T10:41:51Z Indexed on 2010/04/13 10:53 UTC
Read the original article Hit count: 374

Filed under:
|
|
|

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)  
)

© Stack Overflow or respective owner

Related posts about access

Related posts about database