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

The information in this article applies to:

Microsoft Access 2000

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.

Modification Type:	Minor	Last Reviewed:	1/26/2005
Keywords:	kbbug kbfix KB234248