You might want to change the field type from int to identity. The identity
field type in SQL Server is analogous to the Autonumber field type in
Access.

good luck

CJ


"Yan Roosens" <yan.roosens@skynet.be> wrote in message
news:3F7C4258.6C6B428E@skynet.be...
> Hello all,
>
> I'm a total newbie with SQL Server 2000 and I have a little problem when
> moving a database form Access 2000 to SQL Server 2000.
> In the Access database, each table has an auto-increment field.
> After importing the tables in SQL Server, all the auto-increment fields
> are turned into "int" type fields.
> Does anybody have an explanation for that mystery?
>
> Thanks in advance,
> Yan
>
>