Local Professional IT Support For Your Business

I could not get the upsizing Wizard in MS Access to work on this database, so instead I used the SQL Server Management Studio to import the MS access database to the SQL server. This had the unfortunate side effect that the autonumber id field on each table was not marked as such.

So I had to go to the table design and mark the access ID field as  the primary key , and then update the identity attribte to 'yes', this also took the default of 1,1. ie IDENTITY(1,1).