By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,386 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,386 IT Pros & Developers. It's quick & easy.

ODBC conversion error between MySQL and MS Access

P: n/a
MBR
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
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.