SQL i ACCESS - problem sus statementa

Slednia problem:
V MSAccess, kato pravish tablica v design view, mojesh da izberesh edin tip "AutoNumber" za niakoe ot neinite poleta(mnogo podhodiashto za ID, ako niama mreja). Ako obache generiram SQL statement za suzdavane na tablicata:

Create table MyTable(
Age Integer,
Name Text(20).........
............
),
kak da suzdam pole ot tip AutoNumber - niakoi znae li???

The CREATE TABLE DDL Statement
The following create table statement creates a test table with all of the DDL available to Microsoft Access data types:

CREATE TABLE TestAllTypes

   (

      MyText       TEXT(50),

      MyMemo       MEMO,

      MyByte       BYTE,

      MyInteger    INTEGER,

      MyLong       LONG,

      MyAutoNumber COUNTER,

      MySingle     SINGLE,

      MyDouble     DOUBLE,

      MyCurrency   CURRENCY,

      MyReplicaID  GUID,

      MyDateTime   DATETIME,

      MyYesNo      YESNO,

      MyOleObject  LONGBINARY,

      MyBinary     BINARY(50)

    )

Епа, това е моето хоби... [линк]

a az da popitam
poneje vuv MSSQL moga da vzema poslednoto insert-nato id sus SELECT @@IDENTITY
v access po sushtia nachin li stava?
(pitam zashtoto sum si dal diska s office 2000 na edin priatel i niamam access i ne moga da testvam)

Само ако използваш OLEDB 4.0 (Provider=Microsoft.Jet.OLEDB.4.0)...

Епа, това е моето хоби... [линк]