Web Development

Ask something
Discussion Locked

Access 2000: Network Connection Error

0 helpful
3 replies

by ianhayn

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When working in Access 2k over a period of hours I eventually get VBA modules that fail and give a "Network Connection Error". Asking the reason for this I've been pointed at Norton Antivirus being the cause (now eliminated), the use of DAO objects and copying between modules. Nothing yet has resolved the problem, other than taking regular backups of my work (several times a day just in case).

It does appear to be related to the amount of work I do with VBA in any one block of time. Put in simple terms, does it keep track of what its doing in some way and get overloaded?

Any help appreciated

Ian Haynes

3 replies

by fofa

We have had the same problem with Access 97 and 2000. It started when we switched our network hardware over from hubs to switches. It never has been resolved. And it does seem to do with how long the connection is active (not amount of work, at least here). We have VB applications if left open long enough have the same problem when using an Access DB. It wouold appear (and according to MS) that Access more "sensative" to the network connection than other applications. It would appear where other connections reconnect or don't detect a minor interuption in the network connection (for lack of a better term) Access gets "lost". Save often!

This discussion is closed to new replies.