Microsoft KB Archive/295218

= ACC2002: Cannot Select Table in &quot;Select Database and Table&quot; of Data Connection Wizard =

Article ID: 295218

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295218



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

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



SYMPTOMS
When you attempt to link tables to the current Microsoft Access project (.adp), the Select Database and Table screen in the Data Connection Wizard only allows you to select a database, and not a table, as the screen title implies. In addition, the vertical and horizontal scroll bars do not work.



RESOLUTION
To return to the Link Table Wizard, complete the Data Connection Wizard, without choosing a table. Access will display a list of tables and views to which you can link.



Steps to Reproduce the Behavior

 * 1) Start Microsoft Access.
 * 2) On the File menu, click New. Create a new Microsoft Access Project (.adp) that is connected to existing data. For example, connect to the Northwind sample database.
 * 3) On the File menu, point to Get External Data, and then click Link Tables.
 * 4) In the introductory screen of the Link Table Wizard, click Linked Server, and then click Next.
 * 5) In the Select Data Source dialog box, double-click +New SQL Server Connection.odc to start the Data Connection Wizard.
 * 6) In the Connect to Database Server screen of the Data Connection Wizard, specify a valid Microsoft SQL Server name and the appropriate logon credentials. Click Next.
 * 7) In the Select Database and Table screen, select the Northwind sample database in the combo box.

After you select a database, notice that the lower part of this screen displays all tables and views in the selected database. However, the vertical and horizontal scroll bars do not allow you to scroll in the expected direction. In addition, this screen only allows you to select a database, and not a database and table, as the screen title suggests.

Additional query words: pra prb odc connection adp project link table wizard select database navigate scroll bar read-only read only

Keywords: kbprb KB295218

-

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

© Microsoft Corporation. All rights reserved.