Create Table in Access 1

[testeng]

I would like to create a temp table that will be very large so I would like to be able to index certian fields after I create the table but so far I can only create a primary key and thats it.
Here is my string:
strSQL = "CREATE TABLE AutoIncrementTest (ID int identity, F1 varchar(40),F2 varchar(40), CONSTRAINT AutoIncrementTest_PrimaryKey PRIMARY KEY (ID))"
cnDatabase.Execute strSQL, , adCmdText +
adExecuteNoRecords

So from here how can I make colum "f1" indexed?

Thanks for your help

 

[hmckillop]

CREATE INDEX idx_F1
ON AutoIncrementTest (F1)



"Own only what you can carry with you; know language, know countries, know people. Let your memory be your travel bag.