All the fields of a record display #Delete when you copy and paste a record that contains a Null field in Office Access 2003 (922395)


The information in this article applies to:

  • Microsoft Office Access 2003

SYMPTOMS

Consider the following scenario. In Microsoft Office Access 2003, you create a form that is based on a linked Microsoft SQL Server table. You copy and paste a record that contains a null field. In this scenario, you will notice that all the fields of the record display #Delete.

CAUSE

This issue occurs because Office Access 2003 only supports integer identity columns.

WORKAROUND

To work around this issue, use integers in the identity columns.

STATUS

This behavior is by design.
Modification Type:MajorLast Reviewed:7/25/2006
Keywords:kbcode kbExpertiseAdvanced kbprb KB922395 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.