Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 19
Organization: Arcor
NNTP-Posting-Date: 02 Dec 2004 12:46:22 MET
NNTP-Posting-Host: a58bf304.newsread4.arcor-online.net
X-Trace: DXC=Gl27MQXTJCTD__2dTlB=E[:ejgIfPPldTjW\KbG]kaMXXY;eg@jLYe\NQ\`f2NU8P_mnR6@1cH6TQE]KL?G7HZePceTdIGCVST]
X-Complaints-To: ab***@arcor.de
Xref: number1.nntp.dca.giganews.com mailing.database.mysql-win32:6848 mailing.database.mysql:143134
Help!
I am trying to link MySQL tables (4.1.1-alpha-standard,
5.0.1-alpha-nt-max) via ODBC (3.51) to MS Access 2000. OS is Win2k
professional, english version.
Everything is working fine, but columns defined as "time" are first
interpretated as date (e.g. "13:30:00" is changing to "31.05.2015").
When opening the design view of the new table in MS Access and selecting
the particular column, it is possible to select a new format (e.g. "Long
Time"), but now the time is simply "00:00:00". What is wrong?
Also changing the regional options in the control panel of Win2k does
not help. Current setting for time is format: "HH:mm::ss" and time
separator is ":".
Thanks,
Matthias