Article ID: 321901 - Last Review: June 25, 2004 - Revision: 2.0

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

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
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).

Expand all | Collapse all

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  (http://support.microsoft.com/kb/266277/EN-US/ ) PRB: Using the Visual Studio 6.0 and Access 2000 Visual Database Tools with SQL Server 2000
Back to the top
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Back to the top
Keywords: 
kbprb KB321901
Back to the top