Posted by Trevor Best on 10/31/05 10:21
david@epsomdotcomdotau wrote:
> Obscure footnote:
>
>>any floating point columns in your data (including
>>datetime as these are stored as floating point numbers)
>
>
> SQL Server doesn't store datetime as double. Access does,
> and the problem arises because of the rounding error in
> the conversion between the Access version and the SQL
> Server version, even when values are not 'stored' in Access
> at all.
Sorry, my bad. It's 2 ints (or Longs in AccessSpeak).
[Back to original message]
|