????? ??????? "????? ????? ?????" ?? Access 2002

?????? ????????? ?????? ?????????
???? ???????: 330468 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ????? ????? ????? ????? Microsoft Access ???????? ??? Microsoft SQL Server ?? ??? ???? ?????? Microsoft (MSDE) ???????? "????? ????? ?????" Access 2002. ???? ??? ?????? "????? ????? ?????" ?? ?????? ?? ??? ????? ????? ????? ? ???????? ??????? ???????? ??????? ??????? ???????? ??? ???????? ??????? ?? ????? ????? ?????? ?????? ?????? ?????? ??? ???????.

????? ???

???? ??????? "????? ????? ?????" ????? Access ?????? ????? ???????? (mdb.) ??? ?? ????/????. ????? ??????? ?????? ???? ????? ?????? SQL Server ???? (??? ?? ??? ????? ????? ?????? ?? ??? ????????? ?????????? ???????) ??? ?? ???? ???????? ??? ????? ?????? ???? SQL. ???????? ??? ???? ????? "????? ????? ?????" ?????? ????? ??????????? ??? SQL Server ??? ????? ? ?? ????????? ??????? ??? ????? ????? ???? ???? ????.

????? ????? ?????? ???? ????? ???????? ??? ????????? ?? ??? ????? SQL Server ????? ????? ????? ???????? "? ????? ????? ????? ????? ???? ????? ?????? ?? Access. "????? ????? ?????" ???? ????? ????? ???? ??????? ???????? ?? ????? ???????:

  • ???????? ??? ????? ?????? Access (.mdb) ?????? ?? ?? ?????? ??????? ???????? ???? ???? ??????? ????? ????? ?? SQL Server.

    ?????? ????? ?????? ??? ???????? ???? ????? ?????? ????????? ??????? ???????? ?????? ?????? ???????? ?????? ???.
  • ????? ??? ????? Access (.adp) ???? ?? ?? ??? ??????? ? ???????? ????? ?????? ??? ???????? ????? ??????? ? ??????? ??????? ?? ????? ?????? Access ??????? ?? ?? ?????? ??? ??? ????? Access ??? ????? ????? ????? ?? SQL Server.

    ??? ????? ???????? ??????? ? ???????? ???????? ?????? ??? ??????? ???? ???? ??? ????? ???????? ??????? ???????? ?????? ????? ????? SQL Serer ????? ??? ??? ????? ?????????? ??????? ?????? ???????? ?????? ??? ??? ????? ADP ??? ??????. ??? ????? ????? ?????? ??? ???????? ???? ???? ??? ????? ?????? ???? ??? ????? ???????? ??????? ??? ????? ?????.
???? ?? ??? ????? "????? ????? ?????" ??????? ??? ?????. ???? ???????? ??? ??????? ??? ??????? ??? Access ????? ???????? ?????? ?????? SQL Server. ????? ???????? ?? dialects SQL ?????? ????????. ??? ????? ?? ??? ???? ?????? ?????? ?? ??? ?????????? ??????? ?? ??????? ????? ???????? ???? ???? ????? ??? ??????? ?????? ???? ??????????. ????? ?? ????? ?????? ????? ????? ????? ?????? ????? ?? ????? ?????? ??????. ??? ???? ????? ????? ????? ????? ????? ????? ????? ????? "? ?? ???? ??????? ???????. ??????? ?????? ????? ??????? ?? ????? ?? ?????? ??????. ??? ????? ????? ????? ????? "?????" ???? ?????. ???? ??????? ?????? ??????? ???? ????? ????? "?" ??? ????? ???????? ??????? ????????? ???? ??????? ????? ????? ??????? ??? ????? ???? ???????.

????? ?? ????????? ??? ????? ????? "????? ????? ?????" ? ???? ??????? ???????:
  1. ???? ??? ??????? Microsoft Access ?? ??????? ???????.
  2. ???? "????? ????? ?????" ?? Office ????? ?? ?? "????? ???????.
  3. ???? ??? ??? ???? ???????? ???? ?? ???????.
????? ?? ????????? ??? ?????????? ??? ???? ?????? Access ???? ???? SQL Server ? ????? ?????? "????? ????? ?????" ??? ?????????? ???? ??????? ???????:
  1. ???? ??? ??????? Microsoft Access ?? ??????? ???????.
  2. ???? ?????? ?? Microsoft Access ????? ???? SQL Server ?? ????? Office ?? ?? "????? ???????".
  3. ???? ??? ??? ???? ??????? ?????? ?????? ????? ??? Visual Basic for Applications ? SQL ???????? ?? SQL Server.

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

  • ???? ?? ???? ???? ???????? ?? Access ????? ?? ??? ????? ???????? (mdb.). ???? ????? ??????? ???? ???? ???????? ?????? ??????? ??????? ???????.
  • ???? ?? ????? ??? ???? SQL ?? ????????? ???? ???? ?????? MSDE ????? ????????. ???? ?? ????? ??????? ????? ??????. ?????? ??? ??????? ?????? ??? ????? ????? MSDE ?????? ????? ??? "????? ? ????? ? ????? MSDE 2000" ?? ???? MSDN ??? ???:
    Using Microsoft Access 2002 with MSDE 2000
  • ???? ????? ????? ????? ?? ???? ?????? ???? ???? ?? ?? ???? ?????? ?????? ???????? ??? ???? SQL ???? ???? ???????? ???. ???? ? ??? ?? ???? ???? ??? CREATE. ??? ??? ???? ?? ????? ????? ?????? ????? ?? ??????? ??? ?? ???? ???? CREATE ????? ?????? ?????.
  • ?????? ?? ?? ???? ????? ??? ????? ????? ????? ????? ??? ????? ????? ???? ????? ???? ??? ????? ?????? Microsoft Access ?????? ?????.

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

  • ??? ?? ???? ????? ??? ???? ???? ??????? ?? ???????. ???? ????? "????? ????? ?????" ?????? ?? ??????? ??????? ???? ??? ???? ???????. ?????? ?? ????? ?????? ??? ??????? ??????? ???? ???? SQL Server:
    • ?????? ??? SQL Server 6.5 ??? ?? ???? ????? 30 ????? ?? ???. ?????? ??? SQL Server 7.0 ????? ??? ???? ?????? 128 ?????. ????? ???? ??? ???? ??? ?? SQL Server 2000.
    • ??? ?? ???? ????? ????? ??? ?? ????? "at" (@). ?? ???? ?????? ??????? ????? ?? ???? ????? ??????? ($) ????? ????? (#) ?? ????? ???? ????? (_).
    • ?? ????? ??? ?????? ????? ?? SQL Server 6.5. ????? ?? SQL Server 7.0 ?????? ???? ??? ????? ????? ??? ?????? ?????? ("") ?? ????? ????? ([]).
    • ?? ??? ?? ???? ????? ?????? ?????? SQL ????????. SQL Server ???? ???? ?? ?????? ??????? ?????? ??????? ?? ??????? ????????. ?????? ??? ??????? ??? ??????? ???????? Transact-SQL ???? ??? "??? SQL Server ???????".
  • ?? "????? ????? ?????" ????? ??? ???????. ??? ????? ????? ???? ?? ????? ???? ??? ????? "?????". ??? ??????? "????? ????? ?????" ? ??? ?????? ???? ????????? ??? ??????? ??? ??? ????? ? ??? ??????? ? ????????.

    ???? ??? ??????? ?????? "????? ????? ?????" ??????? ??????? ??? ????? ????? ????????:
    • ??? ????? ????? ??????? ??????? ??????.
    • ??? ????? ??????? ??????.
    • ??? ????? ??????? ?????? ??? ????? ?????.
    • ??? ????? ????? ????? ?? ????? (&) ??? ????? ???? (+).
    • ??? ????? ???? ????? ??? ????????? ?? SQL ???????? ?????? ??? ????????.
    • WITH TIES ??? ????? ???? ??????????? TOP ???? ????? ??? ???? ORDER BY.
    ????? ???? ???? SQL Access ??????? ??? ?????? ?? ??? MSDE ?? ?? ??? ?????. ???? "????? ????? ?????" ?????? ??? ??????? ?? SQL ??????:
    • ????? ??????
    • distinctrow
    • owneraccess
    • ???? ?? UNION
    • ORDER BY ?? ????????
    • ???????
    • ??????
  • ?? "????? ????? ?????" ????? ????????? ?????? ???? Access. ??? ???? ?????? ?? ?????? Access ?? ????? ?? ????? ???? ??? ???? ????? ??? ??????? ?????? ?????? ?????? ??? ???????? (DAO) ???? ?? ??????? ?? ??????????? ??? ????????? ???????? "?????? ?????? ActiveX (ADO).

    ?????? ??? ???? ???? ??? ??????? ADO ? ?? ?????? ???? MSDN ??????:

    ????? ?? ???????? Access Components ???? Office

    http://msdn.microsoft.com/en-us/library/aa141802.aspx
    ?????? ??? ????? ?????? ??? ????? ??????? ADO ?? ?????? ???? MSDN ??????:
    ??????? ?? ???? ????/???? Access

    http://msdn.microsoft.com/en-us/library/aa189856.aspx

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

  • ??????? ??? ????? ?????.
    • ???? ?? ??? ??? ???????? ?????????? ?? ?????? ????? ?????? SQL Server ??? ???? ?? 1 ???? ????.
    • ???? ????? ??? ???? ??????.
  • ??????? ???? ??? ????? ???? ??? ????? ???????? ???????? SQL. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    281950ACC2002: ????? ???????? ???? ??? ????? ???? ??? ????? ???????? ???????? ???? SQL

?????

?????? ??? ??????? ?????? ??? ????? ????? "? ?? ?????? ????? ??? MSDN ??????:
???????? Microsoft Access 2002 ?? MSDE 2000
http://msdn.microsoft.com/en-us/library/aa139985.aspx
??????? ??? ???? SQL
http://msdn2.microsoft.com/en-us/library/ms952656.aspx
????? ????? ?????? Access ?? ????? ????? ?????
http://msdn2.microsoft.com/en-us/library/aa164896(office.10).aspx
?????? ??? ??????? ?????? ??? ???????? ???? ?? ?????? ??? ????? ??? SQL Server? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
328319ACC2002: ??????? ?? ????? ????? ????? Access 2002
?????? ??? ??????? ?????? ??? ??? ???? "????? ????? ????? Access 2002" ? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
294407ACC2002: "????? ????? ????? Access 2002" ??? ???? ???????? ?? ???? ???????

???????

???? ???????: 330468 - ????? ??? ??????: 21/???? ??????/1428 - ??????: 3.4
????? ???
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbmt kbdesign kbdatabase kbhowto KB330468 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????330468

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

 

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