Microsoft KB Archive/282328

= ACC2002: #Name Appears in Linked Table When Decimal Field Has Identity Set to Yes =

Article ID: 282328

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q282328



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you view a linked SQL Server table that contains at least one field with a data type of Decimal and if that Decimal field has its Identity property set to Yes, the data in the table appears as #Name.



CAUSE
The regional settings of the operating system are using a comma as the decimal separator.



RESOLUTION
Create a Data Source Name (DSN) that does not use the values of the regional settings. In the DSN wizard, this option is:

Use regional settings when outputting currency, numbers, dates, and times.



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
 Create the following table in the SQL Server sample database Pubs and name it tblTest.

 Add the following data to the tblTest table:

 On the computer on which Access 2002 is running, open Control Panel, open the Regional Settings tool, and then on the Currency tab, assign a comma as the decimal separator. Create a Data Source Name (DSN) on the computer on which Access 2002 is running that points to the Pubs database on SQL Server. When you create the DSN, ensure that the Use regional settings when outputting currency, numbers, dates, and times check box is selected. Open any database, and then link the tblTest table by using the DSN that you created earlier.</li> Open the linked table. Note that the data appears as #Name.</li></ol>

<div class="references_section">