create an autonumber ID field with coding

[drctx]

i want to create an autonumber ID field in an existing table, but when i execute the code i get this error message:

run-time error '3293': syntax arror in ALTER TABLE statment.

Private Sub Command0_Click()
Dim tblName As String
Dim SQLstr, sql1, sql2 As String
tblName = "TCRM File"
sql1 = "alter table add"
sql2 = "ID autonumber;"
SQLstr = sql1 & vbCrLf & sql2
DoCmd.RunSQL SQLstr
DoCmd.OpenTable tblName
End Sub

 

[drctx]

i fixed one problem. i didn't have the table name in the statement. i can get it to work with inserting
ID text(10);

is there a way to set the datatype to autonumber?

 

[drctx]

i found it. use autoincrement instead of autonumber in the sql string.
sql1 = "alter table [TCRM File] add"
sql2 = "ID AUTOINCREMENT;"