>Greetings all...I've read alot about ERROR #1104, and how it boils down to a network connection problem most of the time. In my situation, this must be true, but I find that while my clients must have lost connection for a brief ammount of time, that they can close the app and then re-open it and everything is fine...my question, is there a way to test for #1104 and then execute some code to reconnect to the database?
> I agree that the best thing is to find the root cause, but in my case, this is a slow process, and until then I think it'd be worthwhile to make my app even more bulletproof!!:) Any suggestions?
Don't even think about writing code to "get around" an intermittently bad network connection. You lose the connection, all bets are off. Get your clients to fix their network. If you're firm about it, eventually they will thank you for it!
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up