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

Article translations Article translations
Article ID: 250339 - View products that this article applies to.
This article was previously published under Q250339
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

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

Expand all | Collapse all

On This Page

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.

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

STATUS

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

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.

Properties

Article ID: 250339 - Last Review: February 28, 2014 - Revision: 4.2
APPLIES TO
  • Microsoft Access 2000 Standard Edition, when used with:
    • Microsoft Windows 2000 Standard Edition
    • Microsoft Windows NT 4.0
Keywords: 
kbnosurvey kbarchive kberrmsg kbbug kbfix KB250339

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com