ACC2000: View Designer Does Not Display Field Names in an Access Project (266148)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q266148
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

When you create a view in an Access project, the field list in the View designer does not display any field names. The field list shows only *(All Columns).

CAUSE

The Access project is attached to a Microsoft SQL Server or Microsoft Data Engine (MSDE) database that has a space or a hyphen in the database name or the database name starts with a number.

RESOLUTION

In SQL Server or MSDE, change the database name so that it does not contain a space or the hyphen and does not start with a number.

You can rename the database by using the the stored procedures sp_dboption and sp_renamedb. The following example changes the name of the database from "MyDB Name" to "MyNewDBName."

EXEC sp_dboption 'MyDB Name', 'single user', 'TRUE'
EXEC sp_renamedb 'MyDB Name', 'MyNewDBName'
EXEC sp_dboption 'MyNewDBName', 'single user', 'FALSE'

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. In Microsoft Access, click New on the File menu.
  2. On the General tab of the New dialog box, click Project (New Database), and then click OK.
  3. In the File New Database dialog box, click Create to accept the default name and location of the new project.
  4. On the first page of the Microsoft SQL Server Database Wizard, type the name of the SQL Server, type a valid user name and password, and type Test-Db or Test Db for the name of the new database. Click Finish.

    NOTE: The user name that you use in this step must have CREATE DATABASE permissions on SQL Server or MSDE.
  5. Create and save a new table in the project.
  6. Close the table, and then select the table name in the Database window.
  7. On the Insert menu, click View. Note that the field list does not display any field names.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kbnofix KB266148
©2004 Microsoft Corporation. All rights reserved.