Create MS Access Table with auto increment primary key
843854Mar 16 2002 — edited Jun 1 2007I tried the following SQL statement
"CREATE TABLE Employees (empId INTEGER NOT NULL Primary Key auto_increment, firstName VARCHAR(30) NOT NULL, lastName VARCHAR(40) NOT NULL)";
But failed. Here lists the SQL Exception:
Message : [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Has anyone using JDBC to achieve this?
Thanks.