I'm developing a Coldfusion application which uses Access2000 as the DB, I need to create a query to create a table which is all well and good unitll I tried to insert an autonumer field as the primary key.

Anyone know the SQL to insert a Autonumber field as the primary key?