Trouble in MS Access ODBC MySQL date format

Asked By Jose Mathias 40 points N/A Posted on - 11/29/2012

I am using Access to MySQL database that includes a time field. The connection to ODBC is done however, Access finds the time data as a date format. We all know that MySQL and Access has different way of handling time and date. What's the best solution for this? Please help me..

• Status: Open
• Question Views: 719
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Allen Kenneth 20 points N/A #149072

Trouble in MS Access ODBC MySQL date format

 

Hello Jose,

 

Please be aware that certain MySQL Connector/ODBC versions doesn't convert time values correctly. It only returns Date values, no matter which way you try. Check whether you use such version.

Suggestion is that you change the Connector's version compatible with your operating system.
I believe you will find the problem be gone. 

 

Hope this will help you.

About Allen Kenneth

Questions
1

Answers
100

Best Answers
74

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: MS Access