Hi,
I have a BE on a wired LAN.
Very rare for interruption but power outage or just resetting a Switch/AP without remembering to close all FE (I have 4) give me the above error.
I usually have to click 5 or 6 or more close or X on the window before access closes.
It can of course happen from many forms wherever the DB is currently open, also I do have a timer that checks in to the BE. I could error trap here but would prefer some sort of blanket check
I am assuming there is no way to do this without error checks everywhere but thought ask. I do have error handling in most places but not sure that helps as errors usually warn & continue or go back to previous forms etc & wherever you go it wants data from the BE.
Luckily (touch wood!!) I have never had data corruption but the more times I have to press OK or close I suspect more chance of a problem. A simple close straight off would be safer & easier, especially for my staff.
I have never thought of this in all my years but is there a way to have an error handler that catches if there is not other handling in the class or modules.
Thanks I/A
I have a BE on a wired LAN.
Very rare for interruption but power outage or just resetting a Switch/AP without remembering to close all FE (I have 4) give me the above error.
I usually have to click 5 or 6 or more close or X on the window before access closes.
It can of course happen from many forms wherever the DB is currently open, also I do have a timer that checks in to the BE. I could error trap here but would prefer some sort of blanket check
I am assuming there is no way to do this without error checks everywhere but thought ask. I do have error handling in most places but not sure that helps as errors usually warn & continue or go back to previous forms etc & wherever you go it wants data from the BE.
Luckily (touch wood!!) I have never had data corruption but the more times I have to press OK or close I suspect more chance of a problem. A simple close straight off would be safer & easier, especially for my staff.
I have never thought of this in all my years but is there a way to have an error handler that catches if there is not other handling in the class or modules.
Thanks I/A