Microsoft KB Archive/922395

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

Article ID: 922395

Article Last Modified on 2/7/2007

-

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.

Keywords: kbtshoot kbcode kbexpertiseadvanced kbprb KB922395

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.