ACC2002: Project Table Property with Invalid Setting Is Not Specified in Error Message (282344)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q282344
Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

When you open a table in a Microsoft Access project in Datasheet view, you may receive the following error message:
The setting you entered isn't valid for this property.

To see the valid settings for this property, search the Help index for the name of the property.
However, the property that contains the invalid setting is not specified in the error message.

RESOLUTION

This error message is generated if you have set one of the properties of the table to a value that is invalid for that property. To determine which property has the invalid setting, examine for errors those table properties that you have recently changed.

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 Problem

  1. Start Microsoft SQL Server Query Analyzer.
  2. Connect to a SQL Server computer by using the appropriate authentication.
  3. In the Object Browser, double-click the SQL Server sample database Northwind to expand the tree.
  4. Double-click User Tables, and then right-click dbo.Categories. On the shortcut menu, click Extended Properties.
  5. In the Extended Property dialog box, under Name, type MS_DefaultView, and then under Value, type TestCase. Click OK to accept the changes.
  6. Start Access, and then on the task pane, click Project (Existing Data). Name the project TestError, and then click Create.
  7. In the Data Link Properties dialog box, select the same server that you connected to in step 2, and then type the information required to log on to the server.
  8. Under Select the database on the server, select Northwind, and then click OK.
  9. Open the Categories table. You receive the error message described in the "Symptoms" section.

REFERENCES

For more information about upsizing a database to a SQL Server database, click Microsoft Access Help on the Help menu, type about upsizing a microsoft access database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kberrmsg kbpending KB282344
©2004 Microsoft Corporation. All rights reserved.