ODBC SQL Error Bulk Insert - Null values

[JohnH]

I am getting the error below on a sql db I've been updating for years without
problem using an Access Form.

ODBC SQL Server Driver SQL Server Note: Bulk Insert through a view may
result in base table default values being ignored for NULL columns in the
data file.

I've been running the import form for years using Access 2000-2003-2007 and
SQL 2000 - 2003. The error started after I went in to ODBC - System DSN and
unchecked the ANSI checkboxes on the database. I had done this to accomodate
another issue I had withh the datasouce. Even after I reset the checkboxes I
still get the error. Any help is appreciated.

Thanks
John

 

[Clifford Bass]

Hi John,

I cannot address the issue directly, but I do have a suggestion.
Create two new system DSNs. One that uses the ANSI setting and another that
does not. Then in your database update the links to all of the tables. When
you update them, make sure to check the "Always prompt for new location"
check box. And choose the appropriate new DSN for the tables.

Good luck,

Clifford Bass