Good Morning Halty,
Are you using version 4.5 or earlier? Try setting the Control Panel System
Date settings - Short Date - to a 4 digit year format.
"When you open ODBC flat files that contain a date field with a 21st
century date (4 digits for the year), MapInfo chooses the century according
to the system date, rather than according to the 4-character year data that
exists in the file. The date imports as a 20th century date (e.g., 2001
imports as 1901). Flat files opened directly open with the correct date.
(#17461)".
(Source: MapInfo v4.5 Support Notes April, 1998, MapInfo Corporation)
If you are using version 5 I think the ODBC link should be Y2K compliant.
To quote Mapinfo in an earlier response to this question from myself:
"The ODBC problem you mentioned was, I believe, fixed in version 5.0. We no
longer depend on any string conversions in translating an ODBC date to and
from our internal format."
source: Eric Blasenheim, [EMAIL PROTECTED]
I'd be very interested to know if you find that this is NOT true!
Hope this helps,
regards,
Peter Thake
Ordnance Survey, UK
----------
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MI Latest Access Drivers & Y2K
Date: 28 May 1999 20:54
Halty Barrett@GAPINC
05/28/99 11:45 AM
Hi List,
I have a Y2K issue with Mapinfo and ODBC Access tables. My Access table
has
records with dates in year 2000, 2001 and they are fine. But when I open the
table in MI through an Access ODBC connection, the dates are years 1900,
1901.
When I open the same Access table in MI through the usual table registration
procedure, the years of the dates are correct (2000, 2001).
Clearly this is an ODBC driver issue. Where can I get the latest ODBC
drivers for Access? I tried to find them in the Microsoft website without
any
luck.
Any help will be greatly appreciated.
-Halty Barrett
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
