Access 2000 - Autonumber Field w/ SQL

Anon

Hello,

Does anyone know how to create an autonumber field with SQL for Access 2000 ?

Currently the following does not work

create table ch1(
student autonumber primary key,
question text);

however the following does work:

create table ch1(
student autonumber primary key,
question text);

Obviously the autonumber is the problem, but i need incrementation 🙂

Another way of working this out would be to dump a table already created in visual mode into SQL and then checking out the SQL that the program created.

Many thanks !

Anon

It's not 'autonumber', it's 'COUNT'

Anon

Matt,

Use "Counter" (versus "Autonumber") as the field type.

Tom Dunlap
Info724 Ltd.

Anon

I don't have the count datatype in the datatype dropdown and when I try to create a table using query analyzer it tells me datatype "count" is not found. Can someone please tell me what I need to do?

Thanks,
Matt

Matt wrote:

Hello,

Does anyone know how to create an autonumber field with SQL for Access 2000 ?

Currently the following does not work

create table ch1(
student autonumber primary key,
question text);

however the following does work:

create table ch1(
student autonumber primary key,
question text);

Obviously the autonumber is the problem, but i need incrementation 🙂

Another way of working this out would be to dump a table already created in visual mode into SQL and then checking out the SQL that the program created.

Many thanks !

Anon

Matt,

The datatypes used within Microsoft Access's "Design View" and the types it recognizes when issuing the SQL "Create" statement are sometimes different.

For expample, select "Autonumber" in the drop-down list when you're creating a table using the GUI - but "Counter" when you're issuing a SQL "Create" statement in code.

You'll find that if you use the "Design View" to open a table that you've created using SQL (which includes the "Counter" datatype), that it will list the "Counter" field as "Autonumber". Does this help?

Tom Dunlap

Anon

use autoincrement instead of autonumber. access doesn't recoginze autonumber.

CREATE TABLE CONTACTS1 ( ID AUTOINCREMENT CONSTRAINT PKEY PRIMARY KEY, QUESTION TEXT )