Networking issues with Access -- Alert when connection lost
Posted on 2012-04-11
I have a small network of 6 computers linked to my desktop (which has the back-end data) for an MS Access database. It is an Access 2010 system. I'm getting some networking glitches that cause the front ends to fail. I'm pretty sure it is a hardware issue.
My question, though, is how to create a form that pops up on the front end apps when there is an error in the network. Currently, we only discover the problem when somebody does a search for a customer and it doesn't show any results.
A few times, the network disruption error "The Network Has Lost Connection..." pops up that causes the front end to fail, but that is not the typical symptom when something goes wrong.
Any ideas on alerts?