Microsoft KB Archive/321901

= ACC2000: Linked SQL Server Table That Uses BigInt Data Type as Primary Key Displays #Deleted =

Article ID: 321901

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q321901



Moderate: Requires basic macro, coding, and interoperability skills.

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



SYMPTOMS
All records display #Deleted in a Microsoft Access database (.mdb) that is linked to a Microsoft SQL Server 2000 table.



CAUSE
The linked SQL Server 2000 table has a primary key that is a BigInt data type. The Microsoft Jet database engine incorrectly maps the BigInt data type to a Binary data type.



RESOLUTION
Use the data types Int or Text instead of the BigInt data type.



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

 * 1) Add a field named MyBigInt to any SQL Server 2000 database, and then set the data type to BigInt.
 * 2) Set that field as the primary key.
 * 3) Open Access 2000, and then link to that table using ODBC.
 * 4) Open the table in Access. All records display #Deleted.

