Software

Access 2000 error, "Network connection may have been lost," might indicate Vbe6.dll conflict

In Access 2000, receiving the message "Error accessing file. Network connection may have been lost" may not really reflect a connection issue. Instead, it may merely reflect the hazards of patching security holes over time. The solution is another patch, of course.

Problem

For security reasons, it's imperative that we keep Microsoft Office Suite software patched and up to date. However, patching applications, especially software that is as pervasive and complex as Office, can lead to unexpected and often frustrating consequences. Because security updates from Microsoft are deployed piecemeal, in fits and starts, conflicts and incompatibilities may arise and cause certain operations, which worked in the past, to fail in the present. Unfortunately, the reasons for these failures are not usually obvious.

If you've received the error message "Error accessing file. Network connection may have been lost" while working with Access 2000, you may have the issue described in Microsoft Knowledge Base Article 304548.

Without getting into the mundane details, the basis of the problem is a conflict between Access 2000 and version 6.3.91.8 of the Vbe6.dll. This conflict prevents certain code modules from compiling and running. The failure of the code results in the seemingly unrelated error message.

For example, you may see this error when you're trying to add a combo box to an existing Access 2000 database, as was described in this Tech Q&A question by Highlander718. If the conditions described in Knowledge Base Article 304548 are met, performing all of the proper steps to install your combo box would result in the above error message—an annoyingly frustrating situation to say the least.

Solution

Oddly enough, this obscure error has a very obvious and straightforward solution. You can eliminate this problem, along with a bevy of others, by applying Office 2000 Service Pack 3. All of the issues resolved by Service Pack 3 are explained in Microsoft Knowledge Base Article 326605. Be sure to follow the installation instructions as outlined in the Knowledge Base to avoid additional problems.

Next Steps: Build your skills with these hand-picked resources
>Microsoft Knowledge Base Article - 304548
>Issues fixed in Access 2000 by Office 2000 Service Pack 3
>Access Home Page
>Office 2000 Update: Service Pack 3 (SP3)
>Access reference: Working with tables

Problem

For security reasons, it's imperative that we keep Microsoft Office Suite software patched and up to date. However, patching applications, especially software that is as pervasive and complex as Office, can lead to unexpected and often frustrating consequences. Because security updates from Microsoft are deployed piecemeal, in fits and starts, conflicts and incompatibilities may arise and cause certain operations, which worked in the past, to fail in the present. Unfortunately, the reasons for these failures are not usually obvious.

If you've received the error message "Error accessing file. Network connection may have been lost" while working with Access 2000, you may have the issue described in Microsoft Knowledge Base Article 304548.

Without getting into the mundane details, the basis of the problem is a conflict between Access 2000 and version 6.3.91.8 of the Vbe6.dll. This conflict prevents certain code modules from compiling and running. The failure of the code results in the seemingly unrelated error message.

For example, you may see this error when you're trying to add a combo box to an existing Access 2000 database, as was described in this Tech Q&A question by Highlander718. If the conditions described in Knowledge Base Article 304548 are met, performing all of the proper steps to install your combo box would result in the above error message—an annoyingly frustrating situation to say the least.

Solution

Oddly enough, this obscure error has a very obvious and straightforward solution. You can eliminate this problem, along with a bevy of others, by applying Office 2000 Service Pack 3. All of the issues resolved by Service Pack 3 are explained in Microsoft Knowledge Base Article 326605. Be sure to follow the installation instructions as outlined in the Knowledge Base to avoid additional problems.

Next Steps: Build your skills with these hand-picked resources
>Microsoft Knowledge Base Article - 304548
>Issues fixed in Access 2000 by Office 2000 Service Pack 3
>Access Home Page
>Office 2000 Update: Service Pack 3 (SP3)
>Access reference: Working with tables

About Mark Kaelin

Mark W. Kaelin has been writing and editing stories about the IT industry, gadgets, finance, accounting, and tech-life for more than 25 years. Most recently, he has been a regular contributor to BreakingModern.com, aNewDomain.net, and TechRepublic.

Editor's Picks

Free Newsletters, In your Inbox