Microsoft KB Archive/276389

= Northwind sample database opens with a &quot;Run-time error '3709'&quot; error message in Access 2002 =

Article ID: 276389

Article Last Modified on 8/10/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q276389



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you open the sample database Northwind.mdb, you receive the following error message:

Run-time error '3709':

The Connection cannot be used to perform the operation. It is either closed or invalid in the context.



CAUSE
The Error Trapping option in the Visual Basic Environment (VBE) is set to Break on All Errors.



RESOLUTION
To resolve this problem, follow these steps:
 * 1) Press CTRL+G or click Debug in the error message to switch to the Visual Basic Environment.
 * 2) On the Tools menu, click Options.
 * 3) On the General tab, under Error Trapping, click Break on Unhandled Errors.
 * 4) Close and then reopen Northwind.mdb.



MORE INFORMATION
When Northwind.mdb opens, Visual Basic for Applications code is run that checks to see if the locations of the data access pages are still valid. If not, the code tries to correct those locations. However, this code cannot run correctly if Break on All Errors is enabled.

Additional query words: starts begins start begin when I 3709 get opening starting gives me mdb presents with pops up

Keywords: kberrmsg kbtshoot kbprb kbopenfile kbsampledatabase KB276389

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.