CREATE TABLE and AutoNumber fields

[JTeagle]

I'm trying to create a table that contains an AutoNumber field using the following SQL:

 
CREATE TABLE [tmpTable] ([ID] AutoNumber);

but I get a COM error stating that there's an error in the field description. If I use Long as the data type it accepts it, but according to w3schools online AutoNumber is a perfectly valid Access data type.



I've tried it with all lowercase, with PRIMARY KEY and a few other combinations but it simply refuses. Can anyone tell me what I'm doing wrong here?

I'm using ADO (#importing msado15.dll).

[JTeagle]

but according to w3schools online AutoNumber is a perfectly valid Access data type.

What it doesn't tell you is that you can't actually use that word - I discovered after a bit more of a hunt this morning that I needed to use COUNTER.

Sorry for bringing a question and answering it 5 seconds later...