Hi,
I had the problem that Access lost the connection to my MySQL db after a certain time period. Previously I connected via
Now I connect via DNS set up in the windows control panel. There I checked the box "enable automatic reconnect". With the box checked the connection gets not broken anymore which is great. Now I would like to implement "enable automatic reconnect" in VBA so users of my application do not have to set up a DNS in Windows. Is that possible? Thanks for help! FRANK
I had the problem that Access lost the connection to my MySQL db after a certain time period. Previously I connected via
Code:
Constr = "DRIVER={MySQL ODBC 3.51 Driver};Server=" & Server & _ ";port=" & Port & ";user=" & user & ";Password=" & pw & ";Database=" & Datenbank"