After six years of constant nagging from me, my office has finally implemented a copy of MSSQL to replace Access (Woohoo!), so I am now going through and making changes to my queries, which is going quite well.
The one problem I noticed was that when the server people imported my databases, they did not always preserve the column properties properly. I'm getting "cannot insert null value" errors for columns that should be autonumber and primary key.
1) A query I can issue to check the column properties, and
2) A query I can issue to change an existing column to autonumber and make it a primary key?