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


The information in this article applies to:

  • Microsoft Access 2000
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.

MORE INFORMATION

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.

REFERENCES

For additional information about other problems when you use Access 2000 with SQL Server 2000, click the article number below to view the article in the Microsoft Knowledge Base:

266277 PRB: Using the Visual Studio 6.0 and Access 2000 Visual Database Tools with SQL Server 2000

Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kbprb KB321901
©2004 Microsoft Corporation. All rights reserved.