[dba-SQLServer] Import Errors

I'm beating my head against some import errors that don't make much
sense.  I've got an Access FE with linked SQL Server tables and one
table is giving me "Null value in an auto-number field" errors for two
fields, neither of which is an autonumber.  One of them is actually a
text field declared as varchar in SQL Server.  The other is declared as
a smallint, but is set to allow nulls and is not required.  Neither is
set as an identity field.  HELP!

Charlotte Foust
Infostat Systems, Inc.