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 "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
- In Microsoft Access, click New on the File menu.
- On the General tab of the New dialog box, click Project (New Database), and then click OK.
- In the File New Database dialog box, click Create to accept the default name and location of the new project.
- 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.
- Create and save a new table in the project.
- Close the table, and then select the table name in the Database window.
- 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