Unanswered: How to obtain server's datetime through ODBC/MySQL?
I need to retrieve the MySQL's current time through MyODBC. I am not sure how to achieve this in VBA.
I can do this by creating a pass-through query as:
The problem is I need to store the DSN information with the query which may not be practical.
Is there a special kind of table in MySQL I can create for returning current date/time and Access can link to this table? I was thinking to create a HEAP type table and after inserting a row, retrieve the timestamp field. This would be too complicated to just get the server time I think.