ACC2000: Opening Linked AS400 Table Fails

ID: Q234248

The information in this article applies to:

Microsoft Access 2000

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 AS/400 table, 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://www.microsoft.com/data

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products 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          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 6, 1999