Posted by Neil on 12/18/07 20:14

Using SQL 7 with an Access 2000 MDB front end with ODBC linked tables.

Have a DateModified field which previously was smalldatetime. Changed over
the weekend to datetime. Field is updated with a trigger that sets value to
GetDate().

One record in the table now cannot be updated. In Access, get message:

[microsoft][odbc sql server driver]fractional truncation (#0)
[microsoft][odbc sql server driver]timeout expired (#0)

In QA (using Update), no message; just hangs.

Note that many records in the table have been modified since the change, and
there doesn't seem to be a problem. It just seems to be this one record
(possible others that we haven't come across yet) that will not allow
updates.

Any ideas how to resolve this?

Thanks!

Neil

[Back to original message]