Microsoft KB Archive/266148

= ACC2000: View Designer Does Not Display Field Names in an Access Project =

Article ID: 266148

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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 &quot;MyDB Name&quot; to &quot;MyNewDBName.&quot;

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.



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.
 * 1) Create and save a new table in the project.
 * 2) Close the table, and then select the table name in the Database window.
 * 3) On the Insert menu, click View. Note that the field list does not display any field names.

Additional query words: pra blank empty fieldlist

Keywords: kbbug kbnofix KB266148

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.