????? ??????? ????? ????? ????? ?? Access 2000

?????? ????????? ?????? ?????????
???? ???????: 325017 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

?????

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

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

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

    ?????????? ??????? ?????? ?????? ??? ????? ???? ???? ??? ???????????? ????? ???????? ??????? ???????? SQL Server ????? ??? ??????? ????? ???? ???????????????? ?????? ???????? ?????? ??? ??? ????? ??? ADP ??? ??????. ??? ????? ????? ?????? ??? ???????? ???? ???? ??? ????? ?????? ???? ?????????????? ??? ????? ?????.
?????? ??? ????? "????? ????? ?????"? ???? ???? ????? ??????. ???? ?????????? ????? ??????? ??????? ??? ????? ?????? Access ?????? ?????? SQL Server. ??? ????? ?????????? ?? ????? ???????? ???????? SQL. ??? ????? ?? ??? ???? ?????? ?????? ?? ??? ?????????? ??????? ??? ???? ????? ???????? ???? ????? ????? ??? ??????? ?????? ???? ??????????. ????? ?? ????? ????? ????? ????? ????? ???????? ??????? ?????? ?????? ??????. ??? ???? ????? ????? ????? ????? ????? ????? ????? ?????? ??????? ?? ???? ???????. ??????? ????? ????? ?????? ????? ?? ?????? ??????. ??? ?????? ????? ???????? ???? ??????? ?????. ???? ??????? ?????? ??????? ???? ????? ????? ???? ????? ?????? ?????? ????????? ???? ??????? ????? ????? ???????? ?????? ??? ????? ???????.

????? ?? ????????? ??? ????? ????? "????? ????? ?????"? ???? ??????? ???????:

  1. ???? ??? ??????? Microsoft Access ??? ??????? ???????.
  2. ??? ????? ????? ????? ?? ????????????? ?? "??" ????? ??????? ".
  3. ???? ??? ????? ???? ???????? ???? ?? ???????.
????? ?? ????????? ??? ?????????? ??? ?????? ??? ???? ?????? ????? ???? SQL Server ?????? ?????? ??? ?????????? ?? "????? ????? ?????"? ???? ??????? ???????:
  1. ???? ??? ??????? Microsoft Access ??? ??????? ???????.
  2. ??? ?????? ???? ???? Microsoft Access ? SQLServer ?? ????? Office ?? ?? ????? ???????.
  3. ???? ??? ????? ???? ????? ?? ????? Microsoft Access ??????? ??????.

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

  • ???? ?? ?? ???? ???? ???????? ?? ????? ????????????? (.mdb). ????? ??????? ???? ????? ?????? ??? ???????????? ????? ???????.
  • ???? ?? ????? ??? ???? SQL ?? ?????????? ???? ???? ?????? MSDE ???? ???? ???. ???? ?? ??? ???? ??????? ???????. ?????? ??? ??????? ?????? ??? ????? ????? MSDE? ??????? ??? "????? MSDE" ?? ???? MSDN ??? ???:
    ???? ???????? ? Microsoft (MSDE) ??????? Microsoft Visual Studio 6.0: ????? ?? Jet ?????? ???? ?????? ???? ?????? http://msdn2.microsoft.com/en-us/library/ms811092.aspx
  • ???? ???????? ?????? ??? ??????? ????? ?????? ???? ????? ?? ?? ???? ?????? ?????? ???????? ??? ???? SQL ??? ????? ????? ??. ????? ??? ?? ???? ???? ??? CREATE TABLE. ??? ??? ???? ??????? ????? ?????? ????? ?? ???????? ??? ???? "????? ???????????????".
  • ?????? ?? ?? ???? ????? ??? ?????? ???? ?????? ?????? ????? ??? ????? ????? ???? ??? ????? ???????? MicrosoftAccess ?????.
  • ??? ??? ???? ?????? ????? ??? SQL Server 2000? ???? ????? 2000 sr-1 Update ? Access 2000 ? SQL Server 2000 ????????????? ??? ?????.

    ?????? ??? ??????? ?????? ??? ????? ?????? ??? ?????? "?????" Office 2000 sr-1? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    245025 ????? ?????? ??? ?????? ????? Microsoft Office 2000 SR-1-1/SR-1a

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

  • ??? ????? ???? ??????? ???????? ??? ?????? ?? ??????????. "????? ????? ?????" ????? ?????? ?? ??????? ???????? ???? ?? ???????????. ?????? ?? ?? ???? ????? ???????? ??? ??????? ???????? ???? theSQL ???? ??????:

    • ? SQL Server 6.5? ??? ?? ???? ????? 30 ????? ?? ???. ? SQL Server 7.0? ??? ????? ??? ???? ??? 128 ????? ??? ????? ?????? ? SQL Server 2000 ???? ?????? ?????? 249.
    • ??? ?? ???? ????? ????? ??? ?? ????? "??" (@). ?????? ???????? ?? ???? ?????? ???? ????? ??????? ($)? ????? ????? (#)? ?? ????? ???? ????? (_).
    • ?? ????? ??? ?????? ???? ? SQL Server 6.5. ???? ? SQL Server 7.0 ??????? ???? ????? ??? ?? ??? ??????? ??????? ?????? ("") ?? ????? ????? ([]).
    • ??? ??? ???? ????? ???? ?????? SQL ????????. ????? SQL Server ?????? ??????? ???????? ??????? ??????? ????????. ????? ?? ????????? ??? SQL ??????? ????????? ???? "??? SQL Server ???????".
  • ?? ???? "????? ????? ?????" ????? ?????. ??? ????? ??????????? ???? ????? ?????? ?? ????? ??? ????? ???????.??? ??????? "????? ????? ?????"? ??? ?????? ???? ????????? ???? ?? ??????? ??????? ???? ????? ??? ????? ???????.

    ????? ???? ????? ????? ?????????? ??????? ??????? ??? ????? ????? ????????:

    • ???? ????? ????? ????? ????? ??????.
    • ??? ????? ??????? ??????.
    • ??? ????? ??????? ?????? ??? ????? ?????.
    • ??? ????? ????? ?? ????? (???) ????? (+).
    • ??? ????? ???? ????? ??? ????????? ?? ?????? SQL ????????.
    • ???????? ?? ????? ??? ???? ??????????? ???????? ???? ????? ??? ???? ORDER by.
    ??? ?????????? MSDE ??????? ??????? ???? ???? Access SQL ??? ??? ???????. "????? ????? ?????" ?????? ??? ??????? ?? ?????????????:
    • ????? ??????
    • DISTINCTROW
    • OWNERACCESS
    • ?????? ?? ???????
    • ????? ??? ?? ????????
    • ???????
    • ??????
  • ?? ???? "????? ????? ?????" ????????? ???????? ?????? ?? ??? ??????. ????????? ???????? ???? ???? ?????? ?? ?????? Access ?????? ??????? ???? ??? ????? ?? ??? ?????? ?????? ??? ???????? (DAO) ???? ????????? ??? ??????????? ??? "?????? ?????? ActiveX" (ADO) ????????? ????????.

    ????????? ?? ??????? ADO? ?? ?????? ???? Msdn ??????:

    ????? ?? ?????? ?????? ??? ???????? ?? ?? Officehttp://msdn2.microsoft.com/en-us/library/aa141802 (office.10).aspx
    ?????? ??? ????? ?????? ??? ????? ??????? ADO? ?? ?????? ???? MSDN ??? ??? thefollowing:
    ????? ?? ?????? ??? ???? ??????/??????http://msdn2.microsoft.com/en-us/library/aa189856 (office.10).aspx

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

  • ??????? ??? ????? ?????.
    • ???? ?? ?? ??? ??? ???????? ????????? ????? ????? ???????? ??? ???? SQL ??? ???? ?? 1 ???? ????.
    • ???? ????? ??? ???? ?????? ???.
  • ???? ????? ????? "?????" ??? ?????? ????? ????? ??? SQLServer 2000
  • ?? ???? ????? ??? MDE ??? SQL Server ?? MSDE
  • ???? ????? ???? ?? ???? ????? ????? ??? ?????????? ?? ????????? ??? ?????? ?? ?????? ??? ????? ????? ??? SQL Server 2000? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    269824 ACC2000: ?????? ??? ??????? ??? ?????? 2000 Access ? SQL Server 2000

?????

?????? ??? ??????? ?????? ??? ????? ?????? ?? ?????? ????? ??? ???? ????? Microsoft (MSDN) ???????:
???? ?????? Microsoft (MSDE) ? Microsoft Visual Studio 6.0: "????" ??? ?????? ??? ?????? ????? ??????
http://msdn2.microsoft.com/en-us/library/ms811092.aspx
????? ????? ??? SQL Server
http://msdn2.microsoft.com/en-us/library/ms952656.aspx
????? ????? ?????? Access ???????? "????? ????? ?????"
http://msdn2.microsoft.com/en-us/library/aa164896 (office.10).aspx
????? ?? ????????? ??? Access 2000 ????? ????? ????? ?????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
241743 ????? ????? ????? ?? access 2000 ??? ???? ???????? ?? ???? ???????
????? ?? ????????? ??? ????? ????? ????? Access 2000? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
325019 ACC2000: ????? ?? Access 2000 ????? ????? ?????

???????

???? ???????: 325017 - ????? ??? ??????: 15/?? ??????/1434 - ??????: 4.0
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbwizard kbfunctions kbdatabase kbdesign kbdownload kbhowtomaster kbmt KB325017 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????325017

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

 

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