[AccessD] MySQL / VBA Now() format

kost36 at gmail.com kost36 at gmail.com
Mon Jan 23 13:20:15 CST 2023

Hey all,
I use a MySQL table connected to an access form via ODBC driver (8.0.3) and
I have a problem saving a timestamp field.
The record in MySQL is "yyyy-mm-dd HH:mm:ss"
Based on my pc regional settings ms access shows it as "dd-mm-yyyy
I use Format(Now(), "yyyy-mm-dd HH:mm:ss") but it doesn't make any change. 
Am I missing something ?

More information about the AccessD mailing list