Table columns are not displayed in View Designer (248632)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q248632

SYMPTOMS

When you design a view in an Access project (.adp), no column names are displayed for any table that is inserted in the view.

CAUSE

This behavior occurs in an Access project that is connected to a Microsoft SQL Server database with a name that includes a hyphen ("-") or a period (".").

RESOLUTION

To resolve this problem, you must rename the SQL Server database. Do not include a hyphen in the new name.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office XP.

MORE INFORMATION

Steps to reproduce the problem

  1. Start Access, click the Access database wizards, pages, and projects option, and then click OK.
  2. In the New dialog box, click the General tab.
  3. Click Project (New Database).
  4. In the File name box, type TestADP and then click Create.
  5. When the Microsoft SQL Server Database Wizard opens, select a valid server, login ID, and password. In the What do you want to name your new SQL Server database box, type Hyphen-Test.
  6. Click Next and then click Finish to create the database.
  7. Create a new table in the database with at least one field, and save it.
  8. Create a new view, and show the table you created, adding it to the View Designer Diagram pane.
Note that none of the fields in the table are listed.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug KbClientServer kbfix KB248632 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.