Trouble in MS Access ODBC MySQL date format
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..