ACC2000: Microsoft Jet ??? ????? WHERE ????? ????? ?????? ODBC

?????? ????????? ?????? ?????????
???? ???????: 282604 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ?????? ??????? ??????? ???????? ? ?????? ?????? ??????????.

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

????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? Access 2000 ??????? 1 ????? (SR-1) ?? Microsoft Jet 4.0 Service Pack 5 (???? ?????? SP5) ??? ??????? ??????? ???????? ?? ?????? ?????? ?????? ??? ??? ?????? ?? ??? ?? Jet ?? ????? ?????? ???? WHERE ??? ???? ?????? ODBC ??? ?? ??? ???:
  • ???? ????????? ?????? ??? ??? ????????.
  • ????? ????????? ??? ???? WHERE ?????? ?? ?? OR ? ????? ????? AND.
?? ??? ?? ???? ??????? ????? ?????? ??? ????????? ??????? ????? ?? ???????? ??? ??? ??????. ??? ???? ?????? ??? ??? ??????? ?? ?? ?? ???? ??? ??????. ??? ???? ??? ??? 4.0.4431.x ??????? Msjet40.dll

?????

?? ???? Jet ???? WHERE ??? ?? ??? ???????? ???????? ????. ???? ??? ?????? ?????? ???? ?????? ??? ??????.

????

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

?????

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

??????? ????

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

  1. ??? ???? ??????? ???? ?????? Microsoft SQL Server 7.0 ?????? ????? ??????? ????? ????? ?????? ????? ???? pubs2.
  2. ???? ????? ???????.
  3. ?? ?????? ???????? ?????? ?????? ??????.
  4. ???? ??? ?????? ?????? ??? ????? ?????? ?? ?? ?????? ?????? ?????? ????? ?????? ????? (???? ???? ???????????).
  5. ????? ??? ????? ?????? ????? ??? pubs2 ?? ?? ?????? ???? ??????.
  6. ??? ???? ???? ?? pubs (????????) ??? pubs2 ? ???????? ????? ??????? ?? ?????? ????? ????? SELECT ??????? ?? "??????? ????":
    SELECT * INTO pubs2??????? FROM pubs (????????)??????
  7. ????? ????? ?????? ????? ?? Access ???? Test.mdb.
  8. ????? ???? ???? DSN TestPubs ??? ???? SQL 7.0. ????? ????? ???????? ?????????? ??? pubs (????????) ?? ????? ???? ???? ???????? ????? ??????.
  9. ????? ???? ???? DSN TestPubs2 ??? ???? SQL 7.0. ????? ????? ???????? ?????????? ??? pubs2 ?? ????? ???? ???? ???????? ????? ??????.
  10. ??? pubs.titleauthor Test.mdb ???????? "TestPubs." ?? ??? ???? ???? ??????.
  11. ??? pubs2.authors Test.mdb ???????? "TestPubs2." ?? ??? ???? ???? ??????.
  12. ????? ??????? ???? ??????? ?? ????? ????? "?????" ?? Test.mdb:
    SELECT dbo_authors.au_id, dbo_authors.au_lname, dbo_titleauthor.title_id
    FROM dbo_authors INNER JOIN dbo_titleauthor ON dbo_authors.au_id = dbo_titleauthor.au_id
    WHERE (dbo_authors.au_lname = "Ringer" AND dbo_titleauthor.title_id = "PS2106") dbo_authors.au_lname OR = "??????"
  13. ???? ????????? ???? qSel2Authors.
  14. ?? ?????? Access.
  15. ??? ?????? ?? ???? "????? ?????? ODBC" ?? "???? ??????.
  16. ???? Test.mdb ? ??? ?? ????? qSel2Authors.
  17. ?? ?????? Access.
  18. ????? ?????? ?? ?????? "????? ?????? ODBC" ?? "???? ??????".
  19. ??? ??? ?????? ?? Microsoft Word 2000.
  20. ????? ?? au_id ?? ??? ????.

    ???? SELECT ????? ??????? ???????.
  21. ????? ?? title_id (????_???????) ?? ??? ????.

    ???? SELECT ????? ??????? ???????.

???????

???? ???????: 282604 - ????? ??? ??????: 28/???? ??????/1435 - ??????: 3.1
????? ???
  • Microsoft Access 2000 Service Pack 1
  • Microsoft Data Access Components 2.6
????? ??????: 
kbnosurvey kbarchive kbmt kbbug kbfix KB282604 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????282604

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