Article ID: 250339 - Last Review: August 17, 2007 - Revision: 4.2

ACC2000: "The Expression You Entered Refers to an Object That Is Closed or Doesn't Exist" Error When You Create a New ADP

View products that this article applies to.
This article was previously published under Q250339
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

On This Page

Expand all | Collapse all

SYMPTOMS

When you try to create a new Microsoft Access project file (ADP) or when you try to upsize a Microsoft Access database file (MDB), Access appears to stop responding (hangs), or you receive the following error message:
The expression you entered refers to an object that is closed or doesn't exist.
Back to the top

RESOLUTION

Upgrade the Microsoft Data Access Components (MDAC) on the client computer to version 2.6 or later. You can download the latest version of MDAC from the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e (http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e)
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Back to the top

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Install Access 2000 and the Microsoft Data Engine (MSDE) on a clean Microsoft Windows 2000 computer. Make sure that the Windows 2000 computer is a member of a domain that contains a large number of SQL Servers.
  2. Open the Northwind sample database in Access.
  3. On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.
  4. Click Create new database, and then click Next. Note that the Upsizing Wizard appear to hang. If you click Next again, you will receive the error message that is mentioned in the "Symptoms" section of this article.
Back to the top
APPLIES TO
  • Microsoft Access 2000 Standard Edition, when used with:
    • Microsoft Windows 2000 Standard Edition
    • Microsoft Windows NT 4.0
Back to the top
Keywords: 
kberrmsg kbbug kbfix KB250339
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations