FIX: ??? #DELETED ??? ??????? ??????? ?? ????? ????? CHAR

?????? ????????? ?????? ?????????
???? ???????: 264766 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ??? ???? ?? ???? ODBC ????? ????? ??? ?? ??? ??? ???? (CHAR) ?????? ????? #DELETED ???? ?? ???? ?????? ?? ??? ????.

?????? ??? ??? ???? ???? ?? ??? ???? ????? ???? ??? ???? ?????? ?? ????? ???? ????.

?????

????? ?????? ?? ????? ????? ODBC ???????? (?? "???") ??? CHAR ????? ???? ??? ?????? ???? ??? ??????? ??? ?? ???? ?????? ???? ?????. Microsoft Jet 4.0 ???? ??? ???? ???? ???? ??????, padded ??????? ?? ???? ??????, unpadded. ??? ?????? ???????? Jet ?????? ??? Microsoft Access ?? ???? ?????? ??? ??? ???? ??????.

????

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

???? ??????

?????? ??? ??? ?? ??? ????? (VARCHAR) ??????? ??????? ??????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ?? ????? ??? ??????? ?? Jet 4.0 Service Pack 6 (SP6).

??????? ????

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

????? ????? ??? ??????? ?? ???? ??? ??? ????? ?????? DB2 ?? Oracle Microsoft SQL Server. ???? ?? ??????? ?? ???? ??? ??? ??? ???? ????? ????? 60 ?? ???? ?? ?????? ???????.

??? ??? ???? ODBC ?? ???????? ????? ????? ????? ? ??? ???? ????? Jet ? reselects ????? ???? ???? ? ???? ?? ????? ?? ??????. ????? ??? ??????? ??? ??????? ????? Jet ????? ?????? ???? ??????? reselected ?? ?????? ???? ?? ??????? ?????? ????????.

????? ????? ??? ??????, ??? ??????? ???????:
  1. ????? ????????? ???????? Microsoft Visual Basic ??????? ?????? ???? ???????? ????????:
    Sub GenerateTestTable()
    Dim conn As Object
    Dim i As Long, sql as String
       Set conn = CreateObject("adodb.connection")
       ' Change connection string to point to your SQL Server if needed.
       conn.Open "Provider=SQLOLEDB;Server=(Local);Database=Pubs;UID=sa;PWD=;"
       On Error Resume Next
       conn.Execute "drop table tmp_chartest"
       On Error GoTo 0
       sql = "create table tmp_chartest(f1 char(5) primary key, f2 char(10))"
       conn.Execute sql
        For i = 1 To 70
            sql = "insert into tmp_chartest (f1,f2) values ('"
            sql = sql & Format(i, "000") & "','XXXXXXXXXX')"
            conn.Execute sql
        Next i
        conn.Close
        Set conn = Nothing
    End Sub
    					
  2. ???? ????? Microsoft Access 2000 ?? ????? ????? tmp_chartest ?? ?????? ?? ?????? ???????.
  3. ??? ?????? ??????? ?????? ?? ???????? ??? ??? ??? ?? ??????.
  4. ????? ??? ???? ?? ????? F1 = 071 ? F2 ????? = XXXXXXXXXX.
  5. ??????? ????? ?????? ??? ?? ??? #DELETED ???????? ?? ???? ??????.

???????

???? ???????: 264766 - ????? ??? ??????: 21/???? ??????/1435 - ??????: 3.1
????? ???
  • Microsoft Access 2000 Service Pack 1
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbqfe kbhotfixserver kbbug kbdatabase kbfix kbjet KB264766 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????264766

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

 

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