Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/248632

From BetaArchive Wiki

Article ID: 248632

Article Last Modified on 1/26/2005



APPLIES TO

  • Microsoft Access 2000 Standard Edition



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.


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

Keywords: kbbug kbfix kbclientserver KB248632