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.

Please help.