autonumber fields in SQL Express 2005

[tgh]

I've got an autonumber field in a table that I use to create unique order
numbers in an Access 2007 database. When I upsized the DB into SQL Express
2005, the autonumber field no longer works.
How do I get the Access field to work as an autonumber field in SQL 2005
Express?
Thanks

 

[Piet Linden]

I've got an autonumber field in a table that I use to create unique order
numbers in an Access 2007 database. When I upsized the DB into SQL Express
2005, the autonumber field no longer works.
How do I get the Access field to work as an autonumber field in SQL 2005
Express?
Thanks

Set the field type to integer and then set the Identity property to
True.

 

[Piet Linden]

I've got an autonumber field in a table that I use to create unique order
numbers in an Access 2007 database. When I upsized the DB into SQL Express
2005, the autonumber field no longer works.
How do I get the Access field to work as an autonumber field in SQL 2005
Express?
Thanks

Set the field type to integer and then set the Identity property to
True.

 

[Jeff Boyce]

Piet's suggestions apply to the new table definition in SQL Express.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Piet's suggestions apply to the new table definition in SQL Express.

Regards

Jeff Boyce
Microsoft Office/Access MVP