In a continued effort of creating tables I've encountered another small problem. I can't seem to track down the Autonumber datatype to use in the creation of an Access table from ADO.

This just isn't working:

strSQL = "CREATE TABLE ExhibitorListNew ([ExhibitorID] short," _
        & " [Exhibitor] text(50), [Order] Autonumber)"

Everything works but Autonumber. All help is ALWAYS appreciated.

Thanks in advance,
Sagacious

Hello,

This is not so much a reply, years on, but I spent enough time looking for the answer too that I thought it would be worth posting. Using Office 2003 on XP. The tutorial at http://www.functionx.com/vbaccess/Lesson13.htm shows that COUNTER can be used in place of Autoincrement, so I used in in place of INTEGER for the EmployeeID field in
***************
' Drop the Employees table if it already exists.
On Error Resume Next
conn.Execute "DROP TABLE Employees"
On Error GoTo 0

' Create the Employees table.
conn.Execute _
"CREATE TABLE Employees(" & _
"EmployeeId INTEGER NOT NULL," & _
"LastName VARCHAR(40) NOT NULL," & _
"FirstName VARCHAR(40) NOT NULL)"

' Populate the table.
conn.Execute "INSERT INTO Employees VALUES (1, " & _
"'Anderson', 'Amy')"
conn.Execute "INSERT INTO Employees VALUES (1, 'Baker', " & _
" 'Betty')"
conn.Execute "INSERT INTO Employees VALUES (1, 'Cover', " & _
" 'Chauncey')"
' Add more records ...
********************
from http://www.vb-helper.com/howto_ado_create_table.html. However, had to increment the first three entries manually or they would show up as 1's in the first column of the new table. Similar hint available at http://www.eggheadcafe.com/forumarchives/Accessdevtoolkits/Sep2005/post23732157.asp.

For those still looking.

Kuroneko