How to create table with VBA code that has its ID as AutoNumber?

I tried this function that creates sql string:

Code:

---

Public Function createTableProbaAutoNumber(ByVal tableName As String) As String
    Dim sql As String

    sql = "CREATE TABLE " & tableName & " (ID Long Integer PRIMARY KEY AUTONUMBER, Field1 TEXT)"

    createTableProbaAutoNumber = sql
End Function

---

But it doesn't work.

How can I set a field as AutoNumber with VBA code?
What is the right syntax?

CREATE TABLE Statement (Microsoft Access SQL)
https://msdn.microsoft.com/en-us/lib.../ff837200.aspx