[AccessD] SQL Server - Time only in date field

Gustav Brock Gustav at cactus.dk
Sun Apr 1 07:10:23 CDT 2007


Hi John

That is strange - or it may be a limitation in the upsize wizard - as #12:00:00 AM# is a perfectly valid date value in Access.

/gustav

>>> jwcolby at colbyconsulting.com 01-04-2007 13:54 >>>
In fact my question was more simple than that.  I have values in the date
fields that are #12:00:00 AM# for example.  Those values are NOT valid in
SQL Server, or at least will not upsize correctly.  I had to find and fix
all such values by adding some date to them to make them #1/1/1800 12:00:00
AM#.  Once I did that, the table with such fields would upsize.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 





More information about the AccessD mailing list