MySQL Forums
Forum List  »  Microsoft Access

Re: DATETIME becomes TEXT when linked to MS-Access
Posted by: dhs
Date: May 31, 2005 10:36AM

Alan Searle wrote:
> I am linking MySQL tables to an MS-Access (97)
> front-end with MyODBC and, although most things
> seem to work fine, I find that my DATETIME fields
> become TEXT and are not (even as text)
> updateable.

This is an acknowledged bug: #8363: 3.51.11 incorrectly describes Date field.

It's an ODBC driver conflict, which has been temporarily patched in the new MyODBC driver for Windows version 3.51.11-2

I've tested this and it fixes the problem.

-David Hedrick Skarjune

Options: ReplyQuote

Written By
Re: DATETIME becomes TEXT when linked to MS-Access
May 31, 2005 10:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.