Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 295218 - Last Review: September 26, 2003 - Revision: 3.0
ACC2002: Cannot Select Table in "Select Database and Table" of Data Connection Wizard
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).
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.
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
- Start Microsoft Access.
- 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.
- On the File menu, point to Get External Data, and then click Link Tables.
- In the introductory screen of the Link Table Wizard, click Linked Server, and then click Next.
- In the Select Data Source dialog box, double-click +New SQL Server Connection.odc to start the Data Connection Wizard.
- 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.
- 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.
APPLIES TO
- Microsoft Access 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate