[AccessD] SQL Server - Time only in date field

JWColby jwcolby at colbyconsulting.com
Sun Apr 1 11:46:08 CDT 2007


It is valid in ACCESS, but may not be in SQL SERVER.  Or, as you say, it may
be a limitation of the upsize wizard.  All I know is that once I handled
these (and other date problems) the table moved.   


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Sunday, April 01, 2007 8:10 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL Server - Time only in date field

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 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list