Automate response to Run-time error 3146 ODBC--call failed
I have a number of Excel dashboards running in my factory that refresh each minute, by connecting to a local Access Db and running a number of queries.
The Db itself has ODBC connections to a couple of different SQL database tables. They run fine most of the time but I have a problem with random
3146 ODBC--call failed errors popping up.
I have worked with my IT people and have not really been able to nail down the root cause.
I can click OK on the error popup and the dashboard may refresh fine for anther day or more or it may pop the 3146 error again 10 minutes later. There does not seem to be any real consistency to it.
I have read several posts about missing primary keys in the linked tables as to root cause. That may be true here as well but unfortunately these tables are from a third party vendor and I cannot modify them without creating issues with their software functionality.
Short of an actually fix for the root cause, I am wondering if there is a way through my VBA that I can automate clicking the OK button on the 3146 error popup so that this error is automatically acknowledged and the dashboard can go on about it's business.