From: Michael Widenius Date: April 25 1999 8:19pm Subject: myodb-digest List-Archive: http://lists.mysql.com/myodbc/167 Message-Id: <14115.29980.637375.884098@monty.pp.sci.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "hdevcic" == hdevcic writes: hdevcic> You wrote this in support: hdevcic> Access can't always handle DATE columns properly. If you have a problem with these, change the columns to DATETIME. hdevcic> I would appriciate if you can explain when Access can't support MySQl's DATE type, and is it there way to avoid it. It would make my life much nicer, cause the TIME part of DATETIME is surplus which makes me troubles cause i would have to make many changes to programs which communicate with database. hdevcic> I use Access '97 on WindowsNT Workstation and on Windows 98, hdevcic> MyODBC is latest 2.50.22 Version hdevcic> Mysql server is running on FreeBsd and is 3.21.33b Version. hdevcic> Thank you hdevcic> Hrvoje Devcic Hi! If I remember correctly, the problem is that when Access tries to update a DATE column it will update this with a DATETIME value. (This is abug in Access) For example, Access will do: update stamgegevens SET Geb_datum=19760429000000 where ID = 1; instead of: update stamgegevens SET Geb_datum=19760429 where ID = 1; On the other hand, in the newest MySQL version (3.22.21) both statements should work! Please test using DATE columns and if this doesn't work, mail me all details that I may need to reproduce this! Regards, Monty