Microsoft KB Archive/234248

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.