????? ??????

Select the product you need help with

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

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

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

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

??????: ????? ????? ?????? ??????? ??????? ???????? ? ?????? ?????? ??????????.

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

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

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

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

????

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

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

239114

(http://support.microsoft.com/kb/239114/ )

?????: ?????? ??? ???? ???? ???? ?? ???? ????? ?????? Microsoft Jet 4.0

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

?????

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

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

??????? ????

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

?????? ????? Microsoft SQL Server 7.0 ??????? ?? Access 2000 ???? ????? ????? ?????? NorthwindCS (????? ?????? ????? ???? ????? ????????).

??????? ???? ???? 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

???? ????? ??????? ??????. ???? ????? ????????? MakeTestTables ?? ?? ?????? ??????? ?????? ????? ??????? ????.
???? Access 2000 ?? ????? ????? ?????? Access ????? ???? MyTest.mdb. ?? ??????? ???? ??? ??? ????? ?????? ?????? ? ?? ???? ??? ??? ?????.
?? ???? ?????? ?????? ????? ?????? ????? ??????? ??? ????? ?????? ODBC.
?? ???? ?????? ????? ???? ???????? ??? ?? ????? ??? ???? ?????? (DSN) ???? ???? ??? NorthwindCS.
????? ???????? ??? ??????? GUID_Test ? GUID_Test2 ??? ??????. ???? ??????? ???????? ?? dbo_GUID_Test ????? ? dbo_GUID_Test2. ?? ???? ???????? ????? ???? ??? ColA.
????? ??????? ???? ?? ????? ????? "?????" ???? ????? ?? ?????.
?? ???? ????? ?????????? ???? ??? ??? SQL ?? ??????? ???.

???? ????? SQL ???????:

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

??? ??? ?????? ?????????.
???? dbo_GUID_Test ? dbo_GUID_Test2. ??? ???????? ???????? ???? ????? ?????? ????????? ??????? ?? ??? ?????.

???? ?? ??? GUID ??????? ?? dbo_GUID_Test2.ColA ?? ?????? ?? ????? GUID ?? dbo_GUID_Test.ColA.

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

?????

?????? ??? ??????? ?????? ??? ????? ???? ????? ??????? ???????? ????? UniqueIdentifier ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:

253837

(http://support.microsoft.com/kb/253837/EN-US/ )

ACC2000: ???????? ?? ???? ????? ??????? UniqueIdentifier #

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

???????

???? ???????: 248907 - ????? ??? ??????: 06/?????�??????/1425 - ??????: 3.0

????? ???

Microsoft Access 2000 Standard Edition

kbmt kbbug kbfix KB248907 KbMtar

????? ????

???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????

???? ??? ????? ??????? ?????? ??????????248907

(http://support.microsoft.com/kb/248907/en-us/ )

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