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.
MORE INFORMATION
Steps to Reproduce the Behavior
- Add a field named MyBigInt to any SQL Server 2000 database, and then set the data type to BigInt.
- Set that field as the primary key.
- Open Access 2000, and then link to that table using ODBC.
- 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
Additional query words: prb
Keywords: kbprb KB321901