Autonumber Primary Key

JonnyRPI · June 27th, 2003, 12:17 PM

I am using Access as a front end to my MS SQL Server 2000 database. I would like to be able to have the Primary Key be an autonumber feild, but there does not seem to be an option for that. Any suggestions would be helpfull.

Thanks,
Jon

Bob Bedell · June 27th, 2003, 10:59 PM

Jon,

Set the column data type to 'int', and the identity property
(on the Column tab) to 'yes'. The identity seed and identity increment
properties will automatically be set to 1. Emulates an autonumber.

Sorry if this is a duplicate.

hth
Bob