Mike & Doris Manning
mikedorism at verizon.net
Tue May 31 17:32:54 CDT 2005
Charlotte, How are the fields set up in the original source? Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, May 31, 2005 6:03 PM To: dba-SQLServer at databaseadvisors.com Subject: [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. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com