Can Access VBA Trigger a MySQL Event?
Posted on 2014-10-29
I have a bunch of update queries running on my MySQL server by means of an event set to every 15 seconds. The event is called "Dashboard1" and it will clear the contents of a table then repopulate it with updated data by running about 95 update queries.
This works fairly well for the read only data I want to keep updated for the user, but it would be super useful if instead of using a timer, I could have the user trigger that set of update queries by telling the event to run when the update is actually needed.
Is there a way to do this with VBA?