can you do this?

[ae_jester]

Hi,

Can you create an autonumber field when you are creating a table like this? If so, how????

mySQLstring = "CREATE TABLE " & resTableName & " (ResNumber LONG, CustomerID LONG, ReservationDate DATETIME, FreeDay LONG, Status TEXT (50) );"
        mydb.Execute mySQLstring

[Leather]

Create table Table_name (Field1_Name integer IDENTITY(1,1))

This owrks on SQL server, and access 2000...

[kleinma]

is that via ADO??? I just tried it via DAO and got an error when trying to use the syntax

(Field1_Name integer IDENTITY(1,1))

in access 2000

just asking because by his variable names it looks like he is using DAO

[peet]

use COUNTER

Option Explicit 
Private db As Database 
Private Sub Command1_Click() 
Dim sql As String 
 
'create the database 
Set db = CreateDatabase("C:\NewDB.MDB", dbLangGeneral, dbVersion40) 
 
'add a table with some fields 
sql = "CREATE TABLE TestTable (ID COUNTER, SetName TEXT(50), SetVal TEXT(255), Description TEXT(255))" 
db.Execute sql 
 
End Sub

sql will create a field called ID which will be an autonumber field.