Microsoft Access quits when you save a project from Microsoft Access 2002 file format back to Microsoft Access 2000 format (295267)


The information in this article applies to:

  • Microsoft Access 2002, when used with:
    • the operating system: Microsoft Windows Millennium Edition
    • the operating system: Microsoft Windows 98 Second Edition
    • the operating system: Microsoft Windows 98
This article was previously published under Q295267
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

When you convert a Microsoft Access project (.adp) from a Microsoft Access 2002 file format to a Microsoft Access 2000 file format, you may receive the following error, and then Microsoft Access quits:
Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.

CAUSE

You have Microsoft Data Access Components (MDAC) 2.5 Service Pack 2 or earlier installed on your computer.

RESOLUTION

To resolve this problem, upgrade your computer to MDAC 2.6. You can obtain the latest version of MDAC from the following Microsoft Web site:

http://microsoft.com/data

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem has been corrected in MDAC 2.6.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample project NorthwindCS.adp, and then connect it to a remote SQL Server.
  2. Open several forms, and verify that they work correctly and that they display data.
  3. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2002 File Format.
  4. Save the file as NwindCS2002.adp.
  5. Open NwindCS2002.adp.
  6. Open several forms, and verify that they work correctly and that they display data.
  7. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2000 File Format.
  8. Save the file as NwindCS2000.adp.
  9. Note you receive the error message that is mentioned in the "Symptoms" section of this article.

REFERENCES

For additional information about Microsoft Data Access Components, click the article number below to view the article in the Microsoft Knowledge Base:

231943 INFO: Microsoft Data Access Components (MDAC) Release History

Modification Type:MinorLast Reviewed:11/17/2004
Keywords:kbbug kberrmsg KB295267
©2004 Microsoft Corporation. All rights reserved.