|
HI All,
How do i create a autonumber field in a access database using ASP vbscript
My code intiialy is
inquirySQL = "create table tbl_Increment (ID autonumber, b varchar(20))"
Conn.Execute(inquirySQL)
But i get the error
Microsoft JET Database Engine error '80040e14'
Syntax error in field definition.
/updateTable.asp, line 16
Any help would be appreciated.
Cheers
Steve
|
