Hi folks

I've spent hours trying to find out how I add an auto number field to an Access table created with the following script:

adSQL = "CREATE TABLE " &_
cNewTable &_
" ( File_Name text (50) not null, File_Size integer, Details text (255), Uploader text 50, DateUploaded date, Active yesno)"

Can anyone help?

Thanks