Knowledge Base

ACC2000: Opening a Linked Table from a DB2 Database That Is Running on AS400 Fails

Article ID: 234248

Article Last Modified on 1/26/2005

APPLIES TO

Microsoft Access 2000 Standard Edition

This article was previously published under Q234248

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

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

SYMPTOMS

When you try to open a linked table from a DB2 database that is running on AS400, you may receive the following error message:

Microsoft Access cannot open this table in datasheet view.

RESOLUTION

This issue is resolved by the latest release of Microsoft Data Access Components MDAC 2.1.2.4202.3 (GA). You can download MDAC 2.1.2.4202.3 (GA) from the following Microsoft Web site:

http://msdn.microsoft.com/dataaccess

STATUS

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

MORE INFORMATION

When you link the table, if no Primary Key is found and a unique identifier is selected, you can at least open the table in Datasheet view; however, when you try to close the table, you receive the following error:

This Action will Reset the Current Code in Break mode.

In this case, to close the table, first switch to Design view.

Additional query words: pra

Keywords: kbbug kbfix KB234248

Microsoft KB Archive/234248

Contents