??????? ??? ???? ??????? ?? ????? ?????? Access

?????? ????????? ?????? ?????????
???? ???????: 209126 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

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

?????? ??? ????? Access 97 ?? ??? ???????? ???? 112112.
????? ???? | ?? ????

?? ??? ??????

????? ???

?????? ??? ??????? ????? ????? ???? ????????? ?? Microsoft Access 2000 ?? Microsoft Access 2002 ??? Microsoft Office Access 2003. ??? ????? ???????? ???????:
  • ????????? ?????? ?? ???? ????? ?????? Microsoft Jet
  • ????? ?????????
  • ????? ??????
  • ??????? ?????? ???? ?????????
????? ??? ??????? ??? ?????? ???????? ?????? ?? ????? ?????? ????? ?? ??????? ???????? (?? ???????). ?? ??? ?? ??? ??????? ????? ??? ????????? ?? ????. ??? ???? ???? ????? ?????? ???? ???? ??? ????????? ?????? ?? ??????? ????????. ?????? ??? ???? ?? ????????? ??? ????? ???? ??????? ???????? ????? ????? ?? "????? ??????? ?? Microsoft" ???????? ??????? ???????:
odbc ? ?????? ????????

??????? ????

????????? ?????? ?? ???? ????? ?????? Microsoft Jet

???? ????? ?????? Jet ????? ??? ?????? ?? ???????? ???? ???? ??? ??????????? (? ?????? ???????) ??????. ?????? ????? ???????. ??? ???? ??? ?????? ??????? ????? ??? ??? ???? ????????? ?? ?????? ????? ?????? ?????? ??? ????? ????? ???? ?????? ?????? ??????? ?????????. ??? ???? ???? ?????? ? ???? ????? ??????.

?????? ?? ?? ?????????? ????????? ???????? ?????? ???? ???????? ??????????. ??????? ??????? ?? ??? ??????? ???? ????? ??? ??? ??????????:
  • ??? ??????? ?? ????
  • ??? ????? ???????? ?? ????
  • ???? ??????
  • ???? ?????
  • ??? ??????? ??????? ?????
???????? ??? ??? ?????????? ?????? ?? ????? ?????????? ????????? ????? ???? ?????? ??? ??????? ?? ??????? ????.

??? ????? ?????????? ???? ????? ???????. ??? ??? ??????? ?? ????? ??? ??? ????????? ??? ????????? (?? ??????? ???????? ?????? ??) ?? ??? ????? ????????. ??? ???? ??? ????? ??????? ?? ?????, ?? ????? ? ????? ?????????? ???? ?? ????? ??????? ???? ??? ????? ?????????. ????? ????? ???? ?? ????? ????? ??? ???? ????.

??? ??? ?????? ??? ???? ?? ??????? ??? ????? ???????? ??? ??? ?? ?? ???? ????????? ????? ????? ???????????. ??? ???? ??????? ??? ??? ?????? ?? ?????? ??????? ???????? ?????? ????? ?? ????? ???????? ??? ?? re-compile ????????? ??? ????? ????? ?????? ??? ????? ????????. ??? ?????? ????? ????? ??? ???? ?? ????? ?????? ?????? ????????? ??????? ????? ?? ?? ???? ???????.

?????? ?? ????? ??? ????? ?????? ???? ????? ?????? Jet ?? ?? ????? ????? ????? ????? ???????. ??? ???? ????? ??????? "????? ?????" ?????? ?? ??? ??? ???? ????? ???? ???? ??? ?????.

????? ?? ????????? ??? ??????? ???? ?? ???? ??? ??????? "????? ????? ??????" ?? Access 2000 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
207782??? ACC2000: ??????? ????? ????? ??? ???? ???????? ??????

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

???? ?????? ????? ?????? ??????? ?????:
  • ????? ??????? ???? ?????? ?????? ?? ????????
  • ??? ?????? ??? ????? ??????
?? ???? ????? ??????? ???? ????? ??? ?? ????????, ??? ????? ??? ???????? ?? ?????. ??? ????? ??????? ?????? ?? ??????? ? ????? ?? ???? ??? ???????? ????? ?????? ????.

?? ???????? ????? ?? ????? ??? ??? ??????? ????? ?? ????? ????? "???? ??????" ? ????? ?????? ???? ?? ?????? ??? ?????? ??????? ???? ??? ??????? ?????? ????????? ??? "??? 1 N." ??? ??? ???? ???? ?? ???? ????? ?????? Jet ???? ?????? ?????? ?? ???????? ?? ????? ????????? ???? ?? ??????? ????? ??????, ???? ???? ???????? ???? ?? ???? N ?? "??? 1 N. ???? N ???? ??? ?????? ????????? ?? ??? ???? ???????? ????? ??? ????? ??????.

????? ??? ?????? ????? ???? ????? ?????? Jet ????? ??? ????? ??? ??????:
  • ????? ????????? ?? ???? ????????
  • ??? ???????? ??? ?? ???? ?????????
????? ?????? ?????????? ????????. ????? ???? ????? ?????? Jet ?????????? ?????? ??????.

????? ??????

??? ??? ?????? Microsoft Access 7.0 ?? Access 97 Access 2000 Access 2002 ?? Access 2003 ? ???? ??????? "???? ??????" ?????? ??????????? ?? ????? ???????? ". ??? ????? ???? ??????? ?????? ??????? ???? ????? ?????? Jet ????? "???? ??????" ????? ??????? ??? ??? ??????? ???? ?????? ??????? ???? ????? ?????? Jet ?????? ?????????. ???? ???? ??? ???? ?? ???? "???? ??????" ??????? ???? ???? ?????? ?????? ???????? ?????? ?? ?? ?????????? ?????? ???????? ????? ?? ????? "??????? ?????? ???? ?????????".

?????? "???? ??????" ?? Access 7.0 ?? ?? Access 97, ?? Access 2000 ? ?? Access 2002 ?? ?? Access 2003? ???? ??????? ???????:

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

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

?????? ??????? ????????? ??? ????????? ???????:
  • ??? ????? ????????

    ??? ??? ????? ???????? ?????? ?? ????? ????? ???? ???????????. ??? ??? ????? ???????? ?? reorganized ????? ?????? ???? ??????? ???????? ?? ????? ??????? ????? ???????? ???? ??? ???? ??????? ??????? ??????. ???? ??? ??? ????? ???? ?????? ?????? ??????? ?? ??????? ?? ?????? ??? ??? ???? ?????? ???? ????? ????? ???????? ????? ???? ?????? ???????? ??????? ???? ??????. ??? ??? ????? ???????? ?????? ?? ?????? ?? ??????? ????? ????????? ???? ???? ?? ??????? ???????? ???? ?????? ????.
  • ????? ???

    ????? ?? ??? ??? ???????? ?????? ?????? ???? ????????? ????? ?????? ??? ????? ?????. ?? ????? ????? ????? ??? ??? ??????. ??? ????? ????? ???????? ??????? ??????? ???????? ???? ????? ???????? ?????? ????? ???? ??? ????? ????? ??? ??? ??? ??? ????? ??????. ?????? ???? ?????? ???? ????? ?????? Jet ?????? ???????.

    ?????? ???? ????? ???????? ?????? Jet ???????? ?????? ??????? ???? ???? ???? Access ??? ????? ?????? ????? ???? ODBC ??? Access ?????? ?? ???? ??? ?????? ??????? ??????. ?? ??? ??????? ???? Access ?????? ?????? ?????? ??? ??????? ???????? ?? ??????. ???? ?? ????? ??????? ???????? ?? ????? ?????? ?? ???? ?????.
  • ??? ???? ?? ??? ???????? ???????

    ??? ????? ??? ?? ????? ??? ???? ?? ??? ???????? ???? ?????? ?? ???????? ?? ?????. ???? ????? ?? ?? ?????? ???? ???? ?? ????????? ?? ?????? ??? ??? ????? ???????? ?? ????? ???????? ????????? ??? ??????? ???????? "?" ??? "(??? ?? ????? ??????? ???_????? ??? ??? ???? ????).
  • ????? ?????? ???? ??? ?? ???? ????

    ??? ????? ??????? ????? ?????? ???? ??? ?? ???? ????. ?? ?????? ???? ??? ???????? ?????? ?????? ???? ?????? ????? ???? ???????? ????? ??? ?? ??? ???? ??? ??? ??????.
  • ???? ????? SQL ?? ???????

    ??? ?? ????? ??????? "????_???????" ?????? ?? ????? ??? ????? SQL ? ???? ????? SQL ???????? ?? ?? ?????? ????? "???? ?????" ??? ??? ?????????.
  • ???? ?????? ????????

    ???? ?????? ???????? ?? ??????????? ???????. ??? ??? ?????? ??????? ????? ??? ??? ????? ??? ??????? ??? ?? ??????? ??????? ?? ??? ????? ?? ????? ?????? ?? ??????? ??????? ??????. ?? ?????? ??????? ??? ??????? ????????? Q1 ?????? ????????? Q2:
    Q1: ?????? FROM AS IIF([MyColumn]="Yes","Order Confirmed","Order Not Confirmed") SELECT X;
    Q2: SELECT * FROM Q1 WHERE X = "????? ?????";
    ???? ??? ????? ?????? ??????? IIF ?? Q1 Q2 ????? ?? ???? ?????. ??? ??? ????? ???? ?????? ????????? ?? ??????? ???? ?? ???? ????? ???? ?????????.

    ???? ????? ????? ?????? ????????? ??? ???:
    Q1: SELECT * FROM ?????? WHERE MyColumn = "???" ?
    ??? ???? ?????? ????????? ?? ??????? "? ???? ??? ????????? ?? ???? ???? ??? ????? ?? ?????. ??? ???? ??????? ????? ???? ????? ????????? ?????? ??? ??????? ?????? ????? ????? MyColumn ?? ?? ?????? ????? ?? ????? ?????????. ?? ??????? ?? ?? ??????? ?? ????? ????? ???? ???? ????? ???? "??????" ?? "??????" ???????? ??? ?????? ?? MyColumn.

    ???? ???? ????????? ??? ???:
    ?????? [???? ??????? ??????? ? ???? ???. ??????? ??????? ??? ??????? ???? ??.] ??;
    ??? *
    FROM ??????
    MyColumn WHERE = [??? ???? ??????? ??????? ? ???? ???. ??????? ??????? ??? ??????? ???? ??.];
    ?? ???? ?????? ??????? ??? ??????? ?? ??????? ? ????:
    = IIF([MyColumn]="Yes","Order Confirmed","Order Not Confirmed")
  • ????? ???????? ???

    ????? ???? ?????? ????? ??? ????? ?? ??? ????? ????? "????? ???" ????? ?? ?????? ??? ????? ???? ?????? (???? ????? ???). ??? ???? ??????? ?? ????? ?????? ????? Northwind.mdb ??? ??? ?????? ??????? ?????????? ???? Quantity "??????" ?? ?????? "Order Details" ?? ??????? ??? OrderID "? ????? ????? Group By ????? OrderID ??" Order Details "??????. ??? ??? ?????? "????? ???" ??? OrderID ?? ?????? Orders (????????) ??? ??? ???? ??????? ????? Access ?? ?? ?????? ??????? ????? ?? ????? ??????? ?? ??? ?????? ????????.

    ?????? ??? ???? ???? ?????? "????? ???" ???? ??? ???? ??????. ????? ?? ??? ?????? ?????? ????? ??? ????.

    ??? ??? ??????? ???????? ????? ??? ? ???????? ????? ??????? ?? ??????? ???? ?? ????? ??? ????????? ??? ??????? ????? ???? ?????? ?????. ??? ?????? ????? ?? ???? ????? ?????? ?? ??? ???????????.
  • ???? ?????? ??????? ?????

    ???? ?????? ??????? ????? ?? ?????? ???????? ??? ?????? ??? ???????? ??? ????. ??????? ????????? ?????? ????? ????? ??????.
  • ?????? ???? ????????? ?? ??? ?????? ?? ??? ??? ???????

    ??? ??? ?????? ?????? ?????? ????? ?? ??? ?????? ?? ??? ??? ????? ????? ????? ???? ????? ?????? ?? ??? ??? ??? ????? ????????? ???? ???? ?? ?????? ??? ??? ???? "?????" ?? ??? ?????? "?????" ?? ?????. ?? ??? ??????????? ?? ????? ???? ???? ?????? ????? ???????? ??? ????? ?? ???? "?????" ????? ????? ?? ?????? "?????" ?? ?????.
  • ???? ????? ??????

    ?? ?????? ?????? ????????? ?????.
  • ??????? ????????? ????? ???? ?????? ?????

    ??? ?????? ?? ???? ???????? ?????? ?? ??????? ????????? ????? ???? ?????? ????? ?? ????? ?????????. ?????? ??????? ??????? ????? ?? ??????????? ????? ??????? ?? ???????? ?? ????????? ????. ???? ?? ????? ??????? ????? ????????? ???? ??? ???????? ?? ??? ???????.
  • ???? ??????? ????? ?????? ?????????

    ???? ??????? ????? ?????? ????????? ??? ?????? DLookup ?????? ??? ???????? ?? ???? ??? ????? ?? ?????????. ????? ????? ?????? ????????? ???? ?? Access ? ???? ???? ??? ?? Jet ???? ????? ?????? ?? ???? ????? ??????????? ???? ?????? ????? ?????? ?????????. ????? ?? ???? ??? ????????? ??? ?????? ???? ?? ?????? ??? ?????? ?? ????? ??????? ????.
  • ??????? ?????? ??????? ???????

    ??? ??? ???? ?????? ??????? ????? ??????? ?????? ??????? ??????? ???? ???? ???.
  • ??????? ????? ?????

    ??????? Between... And ?????? ? ?????? ?? ? ? = ???? ????? ??? ?????? ????????.
  • ????? ?????? ??? ??????

    ?? ??? ????????? ????? ????? ????? ????? ?????? ODBC? ???? ????? ?????? ??? ?????? ?????? ????? ??????? FailOnError ??? "???".

?????

????? ?? ????????? ??? ?????? ?????? ?? Microsoft Access 2000 ???? ??? ??????? Microsoft Access ?? ??????? ??????? ? ???? ?????? ?????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.
????? ?? ????????? ??? ?????? ?????? ?? Microsoft Access 2002 ? ???? ??? ??????? Microsoft Access ?? ??????? ??????? ? ???? ????? ???? Access ????? ???????? ?? "????? Office" ?? "????? ???????" ? ?? ???? ??? ??? ???? ???????.

????? ?? ????????? ??? ????? ???? ?? Access 2003 ???? ??? ??????? Microsoft Office Access ?? ??????? ??????? ? ???? ????? ???? ????? ?????? Access ?? ????? ?? ?????? ?? ????? "??????" ?? ???? ??? ??? ????? ???? ???????.

?????? ??? ???? ?? ????????? ??? ??????? ????? ?? Access 2000 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
209564ACC2000: ??? ????? ????? ??????? ????? ??????? ?????

???????

???? ???????: 209126 - ????? ??? ??????: 18/?? ??????/1428 - ??????: 2.5
????? ???
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbmt kbquery kbhowto kbperformance kbinfo kbusage KB209126 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????209126

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

 

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