Date fields in Access

------=_NextPart_000_01BD_01C51621.EEC3AC20
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

When I open a mysql table in Access using myodbc (latest version), the date
fields are becoming text fields, and therefore I can't update them. How do
get the fields to be properly interpreted.



Any help will save my life!



Thanks,



Noam




------=_NextPart_000_01BD_01C51621.EEC3AC20--
Noam Dworman [ Sa, 19 Februar 2005 07:25 ] [ ID #652621 ]

Re: Date fields in Access

Noam Dworman wrote:

>When I open a mysql table in Access using myodbc (latest version), the date
>fields are becoming text fields, and therefore I can't update them. How do
>get the fields to be properly interpreted.
>
>
This is fixed in the latest version of MyODBC. It may not be released
yet, but you can get a link to the pre-release binary by going back
through the forum posts just a little.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak [at] nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Daniel Kasak [ So, 20 Februar 2005 23:01 ] [ ID #654469 ]
Datenbanken » gmane.comp.db.mysql.odbc » Date fields in Access

Vorheriges Thema: ODBC, SQLColumns returns nothing when the column name is specified
Nächstes Thema: Problem with MyOdbc 3.51.11 and MySql4.1.10 and VB .Net