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: 404
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