Microsoft KB Archive/248632

From BetaArchive Wiki

Article ID: 248632

Article Last Modified on 1/26/2005


  • Microsoft Access 2000 Standard Edition

This article was previously published under Q248632


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


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 (".").


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


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.


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.

Additional query words: pra missing empty fields data tables gone project view query design

Keywords: kbbug kbfix kbclientserver KB248632