Refresh linked tables when connection has been lost whit out closing access database
I have MDB database linked to SQL SERVER through VPN connection...
I create links to the sql server with dao method..
everything works fine but when I lost VPN connection i cant refresh links to the tables with ado method, I receive message 3146 sql connection failed
I must close database and start again...
Any idea how to cut previous sql connection and refresh links to the tables with vba code without closing access database
I have MDB database linked to SQL SERVER through VPN connection...
I create links to the sql server with dao method..
everything works fine but when I lost VPN connection i cant refresh links to the tables with ado method, I receive message 3146 sql connection failed
I must close database and start again...
Any idea how to cut previous sql connection and refresh links to the tables with vba code without closing access database
Last edited: