Unable to modify table.
Appears when a new constraint has failed on existing data. Compare the ODBC error text that appears in the Save Incomplete dialog box with the two ODBC errors shown below to determine the appropriate solution.
ODBC error text
[Microsoft][ODBC SQL Server Driver][SQL Server]The column [column name] in table Tmp_ [table name] may not be null.
Explanation
A new database column has been added that doesn't allow null values and doesn't provide a default value. The table name in question appears after "Tmp_".
Action
Change the column properties. Either select the Allow Nulls property or type a Default Value setting.
ODBC error text
[Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to insert the value NULL into column '[column name]', table '[database name] TMP_ [table name]'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]Command has been aborted.
Explanation
The Allow Nulls property on an existing database column has been cleared, but the column has existing null values in it. The table name in question appears after "TMP_".
Action
Go to the column and select the Allow Nulls property.