Article ID: 253837 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2002 version of this article, see 293657
When you open a linked SQL Server table that has a field of type UniqueIdentifier, you see #Deleted in the fields of all records.
You have installed Microsoft Jet 4.0, Service Pack 3, and/or Microsoft Office 2000 SR-1.
Obtain the latest Microsoft Jet 4.0 service pack.
For additional information about how to obtain the latest Jet 4.0 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/239114/ )How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior