autonumber fields in SQL Express 2005

  • Thread starter Thread starter tgh
  • Start date Start date
T

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
 
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
Click to expand...

Set the field type to integer and then set the Identity property to
True.
 
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
Click to expand...

Set the field type to integer and then set the Identity property to
True.
 
Piet's suggestions apply to the new table definition in SQL Express.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Piet's suggestions apply to the new table definition in SQL Express.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top