Reli said:
Has anyone found a way to avoid thhe problem of
"Error accessing file. Network connection may have been
lost"
How can I repair this? I ahve tried the Microsoft
knowledge base but the resolution suggested did not work!
Please help! Thanks.
First make sure that you are receiving this message for the reason
described in the KB article (304548). If that is the case, applying the
SP as indicated in the article should work to prevent further corruption
due to this bug, but -- and this is the important point for you -- it
won't repair corruption in your database that has already occurred. To
fix that, your only real solution is to import all objects into a new
database. Any objects that can't be imported are corrupted, and you'll
have to either recreate them or import them from a backup that was taken
before the corruption occurred.
If you're saying that you applied the SP as directed by the article, and
previously uncorrupted databases are still being corrupted by this bug,
then I don't know what could be wrong but suspect that it's not the same
bug at all. Bear in mind, as Mike Painter pointed out, that you will
quite properly get this message if you're accessing your database over a
network and the network connection is broken.
