Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Linked SQL Server Table That Uses BigInt Data Type as Primary Key Displays #Deleted

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

View products that this article applies to.

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).

↑ Back to the top

Symptoms

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

↑ Back to the top

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.

↑ Back to the top

Resolution

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

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

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.

↑ Back to the top

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

↑ Back to the top

Keywords: KB321901, kbprb

↑ Back to the top

Article Info
Article ID : 321901
Revision : 2
Created on : 6/25/2004
Published on : 6/25/2004
Exists online : False
Views : 278