Is the 'disk error or netwok error' a trapable error? I'm not at work now, so I can't test it now.
If it is trapable, would it then be possible to re-connect using VBA without closing the database application and restart again?
Thanks for your reply RuralGuy