ACC2000: Error Message When Inserting Null Value into a TimeStamp Field of a SQL Server Table (223198)
The information in this article applies to:
This article was previously published under Q223198 This
article applies only to a Microsoft Access database (.mdb).
Advanced: Requires expert coding, interoperability, and multiuser
skills.
SYMPTOMS When you try to insert a Null into a TimeStamp field on SQL Server, you may receive the
following error message: ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]The user can't INSERT a non-null
value into a TIMESTAMP column. Use INSERT with a column list or with a default
of NULL for the TIMESTAMP column. (#273) CAUSE The Use ANSI nulls check box is selected
(checked). RESOLUTION When creating the Data Source Name (DSN), make sure the Use ANSI nulls check box is not selected (is unchecked). STATUS This problem no longer occurs with Microsoft SQL Server
7.0.
Modification Type: | Minor | Last Reviewed: | 1/26/2005 |
---|
Keywords: | kbbug kbpending KB223198 |
---|
|