????? ACC2000: ????? ????????? ??? ????? ?????? ??? GUID ??? ????

?????? ????????? ?????? ?????????
???? ???????: 248907 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ?????? ??????? ??????? ???????? ? ?????? ?????? ??????????.

??? ????? ??? ?????? ??? ??? ????? ?????? Microsoft Access (.mdb).

????? ???? | ?? ????

?? ??? ??????

???????

???? ??????? ?????? ???? ????? ?? ???? ???? SQL ????? ???? ????? ??? ??? ?? ??? UniqueIdentifier ?????? ????? ??? ???? ???? SQL ??????? ???. ??? ??? ???? ??? ????? ??????? ??? ?? ????? ????? UniqueIdentifier ??? ??? ????? ??? ?????? ?? ??? ???????? ?? ?????? ??????.

????

?????? ??? ???? ????? ?? ???? ???? Microsoft Jet 4.0 ???? ????? ??? ????? ???? ?? ???? ????? ?????? Microsoft Jet 4.0.

?????? ??? ??????? ?????? ??? ????? ?????? ??? ???? ????? ?? ???? ????? ?????? Jet 4.0 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
239114?????: ?????? ??? ???? ???? ???? ?? ???? ????? ?????? Microsoft Jet 4.0

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.

??????? ????

????? ????? ????? ??????

  1. ?????? ????? Microsoft SQL Server 7.0 ??????? ?? Access 2000 ???? ????? ????? ?????? NorthwindCS (????? ?????? ????? ???? ????? ????????).
  2. ??????? ???? ???? SQL ??????? ?? ????? ????? ???? ????. ???? ??? ??????? ?????? ?????? ?? ????? ?????? SQL Server ?? MSDE.
    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. ???? ????? ??????? ??????. ???? ????? ????????? MakeTestTables ?? ?? ?????? ??????? ?????? ????? ??????? ????.
  4. ???? Access 2000 ?? ????? ????? ?????? Access ????? ???? MyTest.mdb. ?? ??????? ???? ??? ??? ????? ?????? ?????? ? ?? ???? ??? ??? ?????.
  5. ?? ???? ?????? ?????? ????? ?????? ????? ??????? ??? ????? ?????? ODBC.
  6. ?? ???? ?????? ????? ???? ???????? ??? ?? ????? ??? ???? ?????? (DSN) ???? ???? ??? NorthwindCS.
  7. ????? ???????? ??? ??????? GUID_Test ? GUID_Test2 ??? ??????. ???? ??????? ???????? ?? dbo_GUID_Test ????? ? dbo_GUID_Test2. ?? ???? ???????? ????? ???? ??? ColA.
  8. ????? ??????? ???? ?? ????? ????? "?????" ???? ????? ?? ?????.
  9. ?? ???? ????? ?????????? ???? ??? ??? SQL ?? ??????? ???.
  10. ???? ????? SQL ???????:
    INSERT INTO dbo_GUID_Test2 (ColA, ColB)
    SELECT dbo_GUID_Test.ColA, dbo_GUID_Test.ColB
    FROM dbo_GUID_Test;
    					
  11. ??? ??? ?????? ?????????.
  12. ???? dbo_GUID_Test ? dbo_GUID_Test2. ??? ???????? ???????? ???? ????? ?????? ????????? ??????? ?? ??? ?????.
???? ?? ??? GUID ??????? ?? dbo_GUID_Test2.ColA ?? ?????? ?? ????? GUID ?? dbo_GUID_Test.ColA.

?????

?????? ??? ??????? ?????? ??? ????? ???? ????? ??????? ???????? ????? UniqueIdentifier ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
253837ACC2000: ???????? ?? ???? ????? ??????? UniqueIdentifier #

???????

???? ???????: 248907 - ????? ??? ??????: 28/???? ?????/1435 - ??????: 3.0
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbbug kbfix KB248907 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????248907

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com