Microsoft KB Archive/282344

= ACC2002: Project Table Property with Invalid Setting Is Not Specified in Error Message =

Article ID: 282344

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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 &quot;Symptoms&quot; section.

