Creating Autonumbers in Access 2003 with SQL Server 2K BE

[GrahamK]

Hi All,

I am building a database between SQL Server 2000 and MS Access 2003. I have a question in how do I go about creating autonumbers in my ID fields, becasuse SQL Server didn't have an auto number field type, so I've created all the ID's in my Back End tables as "bigint" data type, but that relies on the user entering the unique record ID.

Any Assistance greatly appreciated!

Many Thanks
Graham

 

[SQL_Hell]

Hi there

You can have autonumber in SQL server 2000 but it is not called 'autonumber', it is called an 'Identity' field.

Go into to enterprise manager create a table with an field of data type int then set the identity property to 'yes' and set the seed to 1.

Any reason you are using bigint? big int is very large and can contain numbers from
-2^63 to 2^63 (-9223372036854775808 - 9223372036854775808)