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


The information in this article applies to:

  • Microsoft Access 2000, when used with:
    • the operating system: Microsoft Windows 2000
    • the operating system: Microsoft Windows NT
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).

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://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

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.
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kbbug kberrmsg kbfix KB250339
©2004 Microsoft Corporation. All rights reserved.