https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/253837&feed=atom&action=history
Microsoft KB Archive/253837 - Revision history
2024-03-29T11:25:39Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/253837&diff=377369&oldid=prev
X010: Text replacement - """ to """
2020-07-21T12:52:25Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:52, 21 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l99">Line 99:</td>
<td colspan="2" class="diff-lineno">Line 99:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><li>Using Microsoft SQL Server 7.0 Enterprise Manager or Access 2000, open the sample project NorthwindCS.adp (log in as the database owner).</li></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><li>Using Microsoft SQL Server 7.0 Enterprise Manager or Access 2000, open the sample project NorthwindCS.adp (log in as the database owner).</li></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><li><p>Create and save the following stored procedure with the default name of StoredProcedure1:</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><li><p>Create and save the following stored procedure with the default name of StoredProcedure1:</p></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><pre class="fixed_text">Create Procedure <del style="font-weight: bold; text-decoration: none;">&quot;</del>StoredProcedure1<del style="font-weight: bold; text-decoration: none;">&quot;</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre class="fixed_text">Create Procedure <ins style="font-weight: bold; text-decoration: none;">"</ins>StoredProcedure1<ins style="font-weight: bold; text-decoration: none;">"</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>As</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>As</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>if exists (select * from sysobjects where id = object_id(N'[dbo].[GUID_Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>if exists (select * from sysobjects where id = object_id(N'[dbo].[GUID_Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/253837&diff=139279&oldid=prev
3155ffGd: importing KB archive
2020-07-18T16:16:30Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB253837"></span>ACC2000: #Deleted in Linked Table Containing UniqueIdentifier =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 253837<br />
<br />
Article Last Modified on 6/24/2004<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Access 2000 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q253837<br />
<br />
</div><br />
<div class="notice_section"><br />
<br />
Advanced: Requires expert coding, interoperability, and multiuser skills.<br /><br />
<br /><br />
This article applies only to a Microsoft Access database (.mdb).<br /><br />
<br /><br />
<br />
<div class="notice_section"><br />
<br />
For a Microsoft Access 2002 version of this article, see [[../293657|293657]].<br />
<br />
</div><br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
When you open a linked SQL Server table that has a field of type UniqueIdentifier, you see #Deleted in the fields of all records.<br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
You have installed Microsoft Jet 4.0, Service Pack 3, and/or Microsoft Office 2000 SR-1.<br />
<br />
</div><br />
<div class="resolution_section"><br />
<br />
== RESOLUTION ==<br />
<br />
Obtain the latest Microsoft Jet 4.0 service pack.<br /><br />
<br /><br />
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:<br />
<div class="indent"><br />
<br />
[[../239114|239114]] How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
=== Steps to Reproduce Behavior ===<br />
<br />
<ol><br />
<li>Using Microsoft SQL Server 7.0 Enterprise Manager or Access 2000, open the sample project NorthwindCS.adp (log in as the database owner).</li><br />
<li><p>Create and save the following stored procedure with the default name of StoredProcedure1:</p><br />
<pre class="fixed_text">Create Procedure &quot;StoredProcedure1&quot;<br />
As<br />
if exists (select * from sysobjects where id = object_id(N'[dbo].[GUID_Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br />
drop table [dbo].[GUID_Test]<br />
<br />
CREATE TABLE [dbo].[GUID_Test] (<br />
[ColA] uniqueidentifier ROWGUIDCOL NOT NULL ,<br />
[ColB] [varchar] (50) NULL )<br />
ON [PRIMARY]<br />
ALTER TABLE [dbo].[GUID_Test] WITH NOCHECK <br />
ADD CONSTRAINT [PK_GUID_Test] PRIMARY KEY NONCLUSTERED ([ColA])<br />
ON [PRIMARY] <br />
<br />
INSERT INTO GUID_TEST VALUES ('{DBAB6FFE-82B2-4D65-819E-32DD4D904C51}',<br />
'TESTRECORD1')<br />
INSERT INTO GUID_TEST VALUES ('{DBAB6FFE-82B2-4D65-819E-32DD4D904C52}',<br />
'TESTRECORD2')<br />
INSERT INTO GUID_TEST VALUES ('{DBAB6FFE-82B2-4D65-819E-32DD4D904C53}',<br />
'TESTRECORD3') <br />
<br />
return<br />
</pre></li><br />
<li>Double-click the StoredProcedure1 stored procedure. This creates a table named GUID_Test in the database.</li><br />
<li>Create a new Access database called MyTest.mdb.</li><br />
<li>On the '''File''' menu, point to '''Get External Data''', and then click '''Link Tables'''.</li><br />
<li>In the '''Link''' dialog box, change '''Files of Type''' to '''ODBC Databases'''.</li><br />
<li>In the '''Select Data Source''' dialog box, open or create a data source name (DSN) that points to NorthwindCS.</li><br />
<li>Create a linked table to the GUID_Test table that you created earlier in SQL Server. If you are asked for an index column, select '''ColA'''.</li><br />
<li>Open the dbo_GUID_Test table. Note that all the fields contain #Deleted.</li></ol><br />
<br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: pra<br />
<br />
Keywords: kbbug kbfix KB253837<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd