ACC2000: Append Query on Linked Tables Adds Incorrect GUID Values (248907)

MORE INFORMATION

Steps to Reproduce Behavior

1. Use either Microsoft SQL Server 7.0 Enterprise Manager or Access 2000 to open the sample database NorthwindCS (log on as the database owner).
2. Use the following SQL syntax to create a new stored procedure. This procedure creates two test tables in the SQL Server or MSDE database.

   Create Procedure MakeTestTables
   
   As
   
   if exists (select * from sysobjects where id =
   object_id(N'[dbo].[GUID_Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[GUID_Test]
   
   if exists (select * from sysobjects where id =
   object_id(N'[dbo].[GUID_Test2]') and OBJECTPROPERTY(id, N'IsUserTable') =
   1)
   drop table [dbo].[GUID_Test2]
   
   CREATE TABLE [dbo].[GUID_Test] (
   	[ColA]  uniqueidentifier ROWGUIDCOL  NOT NULL ,
   	[ColB] [varchar] (50) NULL )            
               ON [PRIMARY]
   
   ALTER TABLE [dbo].[GUID_Test] WITH NOCHECK ADD 
   	CONSTRAINT [PK_GUID_Test] PRIMARY KEY  NONCLUSTERED 
   	([ColA])
               ON [PRIMARY] 
   
   CREATE TABLE [dbo].[GUID_Test2] (
   	[ColA] [uniqueidentifier] NULL ,
   	[ColB] [varchar] (50) NULL ) 
               ON [PRIMARY]
   
   INSERT INTO GUID_TEST VALUES ('{DBAB6FFE-82B2-4D65-819E-32DD4D904C51}',
   'TESTRECORD1')
   INSERT INTO GUID_TEST VALUES ('{DBAB6FFE-82B2-4D65-819E-32DD4D904C52}',
   'TESTRECORD2')
   INSERT INTO GUID_TEST VALUES ('{DBAB6FFE-82B2-4D65-819E-32DD4D904C53}',
   'TESTRECORD3')
   
   return
   					

3. Save and close the stored procedure. Accept the default name of MakeTestTables, and then run the procedure by double-clicking it.
4. Open Access 2000 and create a new Access Database named MyTest.mdb. On the File menu, point to Get External Data, and then click Link Tables.
5. In the Link dialog box, change the Files of type box to ODBC Databases.
6. In the Select Data Source dialog box, open or create a data source name (DSN) that points to NorthwindCS.
7. Create links to the GUID_Test and GUID_Test2 tables on the server. Leave the linked tables with the names dbo_GUID_Test and dbo_GUID_Test2. If you are asked for an index column, select ColA.
8. Create a new query in Design view, but add no tables.
9. In the query design grid, click SQL View on the View menu.
10. Type the following SQL statement:

    INSERT INTO dbo_GUID_Test2 (ColA, ColB)
    SELECT dbo_GUID_Test.ColA, dbo_GUID_Test.ColB
    FROM dbo_GUID_Test;
    					

11. Save and run the query.
12. Open both the dbo_GUID_Test and dbo_GUID_Test2 tables. Size the windows and columns so that you can see their entire contents at the same time.