????? ????? ??????? SQL ?????? ?? ??????

?????? ????????? ?????? ?????????
???? ???????: 303968 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ????????? ??????? ??????? ????????.

????? ??? ??????? ??? ??? ????? ?????? Microsoft Access (.mdb ??.accdb).
????? ???? | ?? ????

??????

??? ??????? ????????? SQL ????????? ?????? ??????? ??? ???? ????? ?????? ODBC. ???????? ??????? SQL ??????? ????? ????? ?????? ?? ??????? ?????? ????? ?? ????? ???? ????? ?????? Microsoft Jet ????????.

??????? ????

?????? ??????? SQL ??????? ??? ????? ????? ??? ???? ?????? ???? (DSN)? ??? ?? ????? ????? ??????? SQL ????????.

????? DSN ?????? ??? ???? ??????? ????? ??? Windows 2003 ?? ????? ??? ???? ??????? Microsoft Windows 2000

  1. ???? ??? ????? ???? ??? ???????? ?? ???? ??? ???? ??????.
  2. ?? "???? ??????"? ???? ????? ??????? ??? ????? ??????.
  3. ???? ????? ??????? ??? ????? ???????? (ODBC).
  4. ?? ???? ?????? ????? ????? ?????? ODBC ? ???? ??? ????? ??????? System DSN .
  5. ???? ??? ?????.
  6. ??? ?????? ??????? ???????.
  7. ???? ??? ?????? ?? ?? ?????? ????????? ???????? ?????? ?????????????.

????? DSN ?????? ??? ???? ??????? ???? ?????? Microsoft Windows Millennium

  1. ???? ??? ????? ???? ??? ???????? ?? ???? ??? ???? ??????.
  2. ?? "???? ??????"? ???? ????? ??????? ??? ????? ???????? (ODBC 32-??).
  3. ???? ??? ????? ??????? System DSN .
  4. ???? ??? ?????.
  5. ??? ?????? ??????? ???????? ??? ?? ???? ??? ?????.
  6. ???? ??? ?????? ?? ?? ?????? ????????? ???????? ?????? ?????????????.

????? ??????? SQL ????????

Access 2002 ?? Access 2003
  1. ?? ?????? "????? ??????"? ???? ??? ????????? ??? ??????? ??? ?? ???? ??? ????.
  2. ?? ???? ?????? ??????? ???? ? ???? ??? ??? ???????? ??? ?? ???? ??? ?????.
  3. ???? ??? ????? ?? ???? ?????? " ????? ???? " ??? ????? ????? ?? ?????????.
  4. ?? ????? ????????? ? ??? ??? ??? ? SQL??? ?? ???? ??? ????????.
  5. ??? ???? ???????? ???? ??? ????? ???? ???? ????? ?????????.
  6. ?? ???? ????? ?????????? ?? ???? ?????? ?? ???????????? ????? ODBC ? ??? ?? ???? ??? ???? ????? (...).

    ?? ??????? ????? ????? ODBC , ????? ????? ??????? ??? ????? ???????? ???? ????? ???????. ????? ????? ??????? ???????? ?? ???? ??? ????? ??? ???? ??????? ??? ?????? ??? ???????????? ?????.
  7. ????? ??? ??????? ???? ???? ?????? ?? ????? ?????????? ???? ??? ??? ??? ??? ???? ??? ????? ?????? ????? ?????? ???? ??????? ?? ??????? ????? ?????????.
  8. ??? ?? ??? ????????? ??? ????? ???????? ????? ????? ??????? ReturnsRecords ??? " ??".
  9. ?? ???? "??????? SQL ????????"? ???? ?????? ?? ???? ?????????. ??? ???? ??????? ?????? ??????? ?????? ??????????? ???? ???? ???? SQL ?? ????? SELECT ?????? ??????? 25 ?????? ??? ?? ???? "???????" ?? ????? ????? ?????? Northwind:
    SELECT TOP 25 orderid from orders
    					
  10. ?????? ?????????? ???? ??? ????? ??? ???? ???????. (?????? SQL returnsrecords ??? ?????????? ???? ??? " ??? " ??? ???? ???????.)
  11. ??? ??? ?????? ?????? Microsoft Access ????????? ??? ????? ???????? ?????? ?? ??? ??????.
?????? access 2007
  1. ?? ????? ??????? " ????? "? ???? ??? ????? ????????? ?? ?????? ???? .
  2. ???? ??? ????? ?? ???? ?????? " ????? ???? " ??? ????? ????? ?? ?????????.
  3. ??? ????? ??????? " ????? "? ???? ??? ???????? ?? ?????? ??? ????????? .
  4. ???? ??? ???? ??????? ?? ?????? ????? ?????/????? ???? ???? ????? ?????????.
  5. ?? ???? ????? ?????????? ?? ???? ?????? ?? ???????????? ????? ODBC ? ??? ?? ???? ??? ???? ????? (...).

    ?? ??????? ????? ????? ODBC , ????? ????? ??????? ??? ????? ???????? ???? ????? ???????. ????? ????? ??????? ???????? ?? ???? ??? ????? ??? ???? ??????? ??? ?????? ??? ???????????? ?????.
  6. ????? ??? ??????? ???? ???? ?????? ?? ????? ?????????? ???? ??? ??? ??? ??? ???? ??? ????? ?????? ????? ?????? ???? ??????? ?? ??????? ????? ?????????.
  7. ??? ?? ??? ????????? ??? ????? ???????? ????? ????? ??????? ReturnsRecords ??? " ??".
  8. ?? ???? "??????? SQL ????????"? ???? ?????? ?? ???? ?????????. ??? ???? ??????? ?????? ??????? ?????? ??????????? ???? ???? ???? SQL ?? ????? SELECT ?????? ??????? 25 ?????? ??? ?? ???? "???????" ?? ????? ????? ?????? Northwind:
    SELECT TOP 25 orderid from orders
    					
  9. ?????? ?????????? ???? ??? ????? ?? ?????? ??????? ??? ????? ??????? ????? . ???????? SQL ?????? ??????? ???? ?????? ???????? ???? ??? ????? ??? ??? ???? ??????.
  10. ??? ??? ?????? ?????? Microsoft Access ????????? ??? ????? ???????? ?????? ?? ??? ??????.

?????

????? ?? ????????? ??? ??????????? ?????????? ???? ??????? "????? ??????? ?????? ???? ??????? ??? ????? ?????? SQL" ?? ?????? "????? ??????? ??? ? SQL" ?? ??????? Access.

????? ?? ????????? ??? ????? DSNs ???? ??? ????????? ????? ??????? ????? ?? ?? ???? ??? ??????? ODBC.

???????

???? ???????: 303968 - ????? ??? ??????: 05/?? ?????/1434 - ??????: 7.0
????? ???
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbquery kbsqlprog kbhowto kbmt KB303968 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????303968

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

 

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